10 Replies Latest reply: Apr 14, 2015 10:11 AM by Federico Velasco RSS

    Two fields calling another table

    Beaulieu Mathieu

      Hi,

      I have a question.

      I have a table "Employes" and a table "Datas".

      Like this :

       

      Employes :

      KeyUserName
      080503Community Qlik !
      080504Smiley cool
      080505No records

       

      Datas :

      DateKeyUserCreateKeyUserModify
      13/04/2015080503080504
      14/04/2015080503080503
      14/04/2015080504080503

       

      I would like this result

      DateKeyUserCreate

      NameCreate

      KeyUserModifyNameModify
      13/04/2015080503Community Qlik !080504Smiley cool
      14/04/2015080503Community Qlik !080503Community Qlik !
      14/04/2015080504Smiley cool080503Community Qlik !

       

      I've tried to create two tables Employes but it doesn't works.

       

      Could you help me?

       

      Thanx