Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
amijit_hazarika
Contributor III
Contributor III

Showing same field as Client or Employee

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 1Header 2
NameClient/Internal
AClient
BClient
CInternal
DClient


Any input of how we can achieve this would be helpful.

Thanks

1 Reply
miskin_m
Partner - Creator
Partner - Creator

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..