Dear Martin,
Now I see what's going on. Thank you very much for clarifying the underlying problem and the solution!
Best,
Michi
Search found 2 matches
- Wed Nov 25, 2020 12:41 am
- Forum: PATSTAT Product Line
- Topic: Counting patents by IPC subclass
- Replies: 2
- Views: 2227
- Mon Nov 23, 2020 7:05 pm
- Forum: PATSTAT Product Line
- Topic: Counting patents by IPC subclass
- Replies: 2
- Views: 2227
Counting patents by IPC subclass
Dear PatStat experts: I'm counting patents by IPC subclass. Something like the following query worked fine a year ago (with PatStat Online 2019 Autumn), but now I'm getting an error (with the 2020 Autumn): Invalid column name 'ipc_subclass'. SELECT psn_id, psn_name, a.appln_filing_year, LEFT(ipc_cla...