Joining datasets error but columns do not have issues mentioned in the error message

TMC2159
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!

Answers

  • Clément_Stenac
    Clément_Stenac Dataiker, Dataiku DSS Core Designer, Registered Posts: 753 Dataiker
    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 ?
Setup Info
    Tags
      Help me…