Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI.
I want to add an empty column in load script.
I have my visualization with column name called as CITY. But the table extracted from database doesn't have the field CITY. How can i add the column name CITY in load script.
I tried doing
abc:
load
..
..
..
..
;
table1:
load *,
'city' as [CITY];
resident abc;
drop table table1;
I am new to qliksense. Do help.
Hello, @qlikuser22 !
Quite a common situation.
Try to use Resident (as in your example), Concatenate or Join instruction
1) Resident
[tmp]:
Load * From ... ;
[result]:
NoConcatenate
Load *, Null() as [City]
Resident [tmp];
Drop table [tmp];
2) Concatenate
[result]:
Load * From ... ;
Concatenate([result])
Load * Inline [City];
3) Join
[result]:
Load * From ... ;
Left Join([result])
Load * Inline [City];
Hi @qlikuser22, I wonder why if you do not have City field you want to show it in a visualization. I think it is easier to remove that field from your chart.
JG
Hello, @qlikuser22 !
Quite a common situation.
Try to use Resident (as in your example), Concatenate or Join instruction
1) Resident
[tmp]:
Load * From ... ;
[result]:
NoConcatenate
Load *, Null() as [City]
Resident [tmp];
Drop table [tmp];
2) Concatenate
[result]:
Load * From ... ;
Concatenate([result])
Load * Inline [City];
3) Join
[result]:
Load * From ... ;
Left Join([result])
Load * Inline [City];
Thanks @nikolay_dolgono . The option 2, concatenate worked out and solved my issue. Thanks a lot!