Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 !
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 !
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