Solved: Problem importing data fron an ODBC source.... - Qlik Community

Report Inappropriate Content · ‎2011-03-18

Hello ...
I'm importing our sales data through ODBC interface. I have items with code "08020"and the article code "8020", which are all seen with the code "08020", thereby distortingthe data revenue.
How can I fix it??

Miguel_Angel_Baeyens · ‎2011-03-18

Hello,

Use Text() function in the load script so it will respect leading zeroes:

Table:LOAD Text(Code) AS Code;SQL SELECT CodeFROM Datasource;

Hope that helps.

View solution in original post

Miguel_Angel_Baeyens · ‎2011-03-18

Hello,

Use Text() function in the load script so it will respect leading zeroes:

Table:LOAD Text(Code) AS Code;SQL SELECT CodeFROM Datasource;

Hope that helps.

Report Inappropriate Content · ‎2011-03-18

Ok!!! Everything's ok now. Thank's