2 Replies Latest reply: Oct 26, 2016 12:54 PM by Andy Weir RSS

    Associations in Qlik Sense

    David Pardoe

      I have several "transaction" tables which have a date field in them. I also have a date look up table which tells me which company specific time period a date belongs to. I therefore need to associate the date fields in the transaction tables with the date field in the look up table. Currently the date fields in the transaction tables have different names to the date field in the look up table. When I try and create the associations in the Data Manager it starts breaking some other associations (I have 6 different transaction tables).

       

      Is there any way to create associations in the load script?

       

      Or do I need to ensure all of the date fields are called the same thing?