Search found 14 matches

by Fr3dY
Fri May 17, 2019 3:49 pm
Forum: PATSTAT Product Line
Topic: PATSTAT - ORACLE loading scripts
Replies: 8
Views: 3058

Re: PATSTAT - ORACLE loading scripts

Update: Added scripts for PATSTAT 2019 Spring Edition
by Fr3dY
Thu Feb 21, 2019 9:11 am
Forum: PATSTAT Product Line
Topic: PATSTAT - ORACLE loading scripts
Replies: 8
Views: 3058

Re: PATSTAT - ORACLE loading scripts

Good Mornings, There is a different way to receive PATSTAT 2018 AUTUMN Edition - Oracle Script , such as e-mail? It is impossible for me to download it from tinyupload for security reasons. The TinyUpload.com site is blocked by our proxy due to its poor reputation. Regards. Hi, Send me a private me...
by Fr3dY
Mon Nov 12, 2018 5:16 pm
Forum: PATSTAT Product Line
Topic: PATSTAT - ORACLE loading scripts
Replies: 8
Views: 3058

Re: PATSTAT - ORACLE loading scripts

Update: Added scripts for Patstat 2018 Autumn Edition
by Fr3dY
Wed Sep 19, 2018 9:14 am
Forum: PATSTAT Product Line
Topic: retrieve results of a custom sql query from a database connection
Replies: 3
Views: 889

Re: retrieve results of a custom sql query from a database connection

Hi Sarah,

I don't have any experience with Talend myself, but this link might help you:
https://help.talend.com/reader/Dx4Xf8yk ... zg9k_R4d6w





Regards,
by Fr3dY
Fri Jun 08, 2018 2:47 pm
Forum: PATSTAT Product Line
Topic: Only 30% person_address available?
Replies: 2
Views: 883

Re: Only 30% person_address available?

OK, thanks!!
by Fr3dY
Fri May 18, 2018 9:42 am
Forum: PATSTAT Product Line
Topic: Only 30% person_address available?
Replies: 2
Views: 883

Only 30% person_address available?

Hi, Just wanted to verify if only about 30% of person addresses are available (for RAW data): select count(*) from patstat2018a.tls206_person where psn_sector='INDIVIDUAL' and person_address is not null; 3.653.560 select count(*) from patstat2018a.tls206_person where psn_sector='INDIVIDUAL' and pers...
by Fr3dY
Tue Apr 24, 2018 3:22 pm
Forum: PATSTAT Product Line
Topic: PATSTAT - ORACLE loading scripts
Replies: 8
Views: 3058

Re: PATSTAT - ORACLE loading scripts

Update: Added scripts for Patstat 2018 Spring Edition
by Fr3dY
Tue Feb 20, 2018 9:56 am
Forum: PATSTAT Product Line
Topic: Import data from excel - PATSTAT 2017 Autumn
Replies: 2
Views: 1230

Re: Import data from excel - PATSTAT 2017 Autumn

Hi all, I am using PATSTAT 2017 Autumn version. I have a list of publication number kept in excel file and I want to extract IPC codes associated with those publication numbers. But the problem is that this list contains approximate 8000 unique publication numbers. Its very time consuming for me to...
by Fr3dY
Tue Oct 31, 2017 4:12 pm
Forum: PATSTAT Product Line
Topic: PATSTAT - ORACLE loading scripts
Replies: 8
Views: 3058

Re: PATSTAT - ORACLE loading scripts

Updated: Added scripts for Patstat 2017 Autumn Edition
by Fr3dY
Tue May 16, 2017 10:49 am
Forum: PATSTAT Product Line
Topic: problems with "group by" in my query
Replies: 1
Views: 605

Re: problems with "group by" in my query

Hi, I think you should first try to understand how to use the "group by" clause, for example by looking at http://www.zentut.com/sql-tutorial/sql-group-by/ or even youtube videos, that might be more begginer-friendly (https://www.youtube.com/watch?v=E3rXVrTTROU). Then, about your query... I didn't v...