Blank Values into "n/a"

[QlikApprentice]

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)

[Arthur_Fong]

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

[QlikApprentice]

It didn't work.

[Arthur_Fong]

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