Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

Re: Load CSV file

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
Highlighted
Partner
Partner

Re: Load CSV file

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

Highlighted
Creator
Creator

Re: Load CSV file

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