Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
everest226
Creator III
Creator III

Load CSV file

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.

Labels (1)
1 Solution

Accepted Solutions
fredericmante
Partner - Contributor III
Partner - Contributor III

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 !

 

View solution in original post

2 Replies
fredericmante
Partner - Contributor III
Partner - Contributor III

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
Creator II
Creator II

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