1 Reply Latest reply: Jun 4, 2018 3:22 AM by Miskin Mazgaonkar RSS

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


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

       

      Thanks