Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

amijit_hazarika
New 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
Contributor

Re: Showing same field as Client or Employee

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