Search found 4 matches

by techno
Thu Aug 25, 2016 10:13 am
Forum: PATSTAT Product Line
Topic: Help with IPC Co-Classifikation
Replies: 6
Views: 2210

Re: Help with IPC Co-Classifikation

Thank you very much for your time and help! The query helps me very much.
by techno
Wed Aug 24, 2016 2:04 pm
Forum: PATSTAT Product Line
Topic: Help with IPC Co-Classifikation
Replies: 6
Views: 2210

Re: Help with IPC Co-Classifikation

Thanks for your answer!

My request will be one table that has the information for all Co Classification pairs. But I don’t know how this will be work.
by techno
Wed Jul 27, 2016 2:08 pm
Forum: PATSTAT Product Line
Topic: Help with IPC Co-Classifikation
Replies: 6
Views: 2210

Re: Help with IPC Co-Classifikation

Thanks for your answer. I worked with an old version. Now I tried it with the new version but it doesn’t works. I hope you can help me again. That’s my query: select count(distinct t1.APPLN_ID) as Quantity from TLS230_APPLN_TECHN_FIELD t1 inner join TLS230_APPLN_TECHN_FIELD t2 on t1.APPLN_ID = t2.AP...
by techno
Tue Jul 26, 2016 11:31 am
Forum: PATSTAT Product Line
Topic: Help with IPC Co-Classifikation
Replies: 6
Views: 2210

Help with IPC Co-Classifikation

It is the first time I use PATSTAT for research purposes and I'm not quite sure how to go along. I used an offline version. I want to do a simple co classification analysis on IPC Codes. Therefore I create a table trough a join (table named IPC2) which include the information of tls209_appln_ipc and...