Load CSV file

[everest226]

HI I have Customer number in CSV file which in fetch in application its reads as an same customer .

0005421

5421

These both customer are different but its reading as one customer .

Any Idea.

[fredericmante · Accepted solution]

Hello
Use the text (exp) function

LOAD text(numb) as numb
FROM
[C:\Users\OPSO\Desktop\Classeur1.csv]
(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

Hope this help !

[AdiPai]

Technical solutions apart , 

0005421

5421 

are different customers ? someone needs to fix this first 🙂 

if QLIK is consolidating data from 2 systems - then maybe a combined key would be helpfull - Source1-5421 .. Source2-5421