Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Error ODBC when added merged columns

Hi , I got this error ODBC: ERROR [42000] [SAP AG][LIBODBCHDB DLL][HDBODBC] Syntax error or access violation;257,  when I inserted step for merged columns. Ex inserted step: = Table.AddColumn(#"Add...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

I use Hana Database connector.

Steps before the probelm is Added items, works fine I can see the data from the Query,

then Inserted merged column = generate the error.

No steps after

 

 

StefanoGrimaldi's avatar
StefanoGrimaldi
Icon for Resident Rockstar rankResident Rockstar
5 years ago

try a mor simply approach to see what happend instead of using the combine function use a costum column like this = Column1&"-"&Column2 

and lets see what error says over here. 

also try loading the query to the model an see the full table of data without any step.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    = Column1&"-"&Column2 give the same Error message,

    I also tryed  =Column1&Column2  and thid works fine, Looks like it dosn't like the double quote " " and columns combination