Showing same field as Client or Employee

[amijit_hazarika]

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

[miskin_m]

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