Discussion board where members can get started with Qlik Sense.
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.
Any input of how we can achieve this would be helpful.
Please find the below code..
'Client' as flag
from client excel
'Internal' as flag
from Internal Excel
hope this help..