Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I searched and tried to apply many posts here and elsewhere but could not find the solution. Please keep in mind I'm at the very beginning of using QlikView.
I joined two files into one Table box but when I tried to change the blanks into "n/a" it didn't work. Don't have idea what to try next.
My script is:
LOAD CODE as ID,
Name as Name_1
FROM
[Path.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq)
join
LOAD CODE as ID,
LastName as LastName_1
FROM
[path.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq)
Hi,
Try the script below:
NullAsValue *;
Set NullValue = 'n/a';
LOAD CODE as ID,
Name as Name_1
FROM
[Path.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq)
join
LOAD CODE as ID,
LastName as LastName_1
FROM
[path.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq)
Thanks and regards,
Arthur Fong
It didn't work.
Can you please screenshot your result?
Please also share both your raw tables so that we can identify what is the root cause.
Thanks and regards,
Arthur Fong