topic Load CSV file in QlikView

Load CSV file

everest226 — Sat, 16 Nov 2024 01:44:49 GMT

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 — Mon, 09 Dec 2019 17:07:54 GMT

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 — Mon, 09 Dec 2019 17:12:05 GMT

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