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.
|Header 1||Header 2|
Any input of how we can achieve this would be helpful.