Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlik Community,
I have a field called Name. The field Name comes from two different source excel spreadsheet(Client and Internal).
I need to create a straight table and show two columns; Name and Client/Internal.
If the name comes from Client spreadsheet then the name should be shown as Client and if it comes from Internal spreadsheet then it should show as Internal.
Ex:
Header 1 | Header 2 |
---|---|
Name | Client/Internal |
A | Client |
B | Client |
C | Internal |
D | Client |
Any input of how we can achieve this would be helpful.
Thanks
HI,
Please find the below code..
Load
Name,
'Client' as flag
from client excel
concatenate
Load
Name
'Internal' as flag
from Internal Excel
hope this help..