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?
You can do as mark suggests and name all your date fields the same and let qlik associative data model do the rest or you can set up a master calendar and link the transaction dates to it using set analysis when you create specific charts. More work with the second option but you will have more flexibility.