Joining datasets error but columns do not have issues mentioned in the error message
TMC2159
Registered Posts: 2 ✭✭✭✭
When trying to join two datasets I get the following error:
An invalid argument has been encountered : in act.compute_1stOAMatrix_NP: Column name can not contain comma, quotation mark, leading or trailing white spaces with DSS engine (when using H2).
However, both datasets do not contain comma, quotation mark, leading or trailing white spaces as per indicated.
This seems to happen once a pivot was applied to one of my sets.
Any help would be very much appreciated!
An invalid argument has been encountered : in act.compute_1stOAMatrix_NP: Column name can not contain comma, quotation mark, leading or trailing white spaces with DSS engine (when using H2).
However, both datasets do not contain comma, quotation mark, leading or trailing white spaces as per indicated.
This seems to happen once a pivot was applied to one of my sets.
Any help would be very much appreciated!
Tagged:
Answers
-
Hi,
Can you go in the settings of your input datasets > Schema, click on "Export schema", choose CSV, and attach the resulting CSV data for both datasets here ?
