Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have a 2 files and it has 2 fields that same for project and date. I asscociate project but when i do for date, the project association went missing. Please help me
I just looked into your file (.qvf)
you are using the Data Manager and not the script editor
in the Schema I found that the two tables are related via the common field "Date Combined"
now if you want to link the two tables via the 2 columns Project and Date Combined, then both tables should have the same field name for the project
but keep in mind that when two tables have more than one column in common then synthetic keys will be created and this is not recommended in qlik so you have to create composite key in both tables like Project & '|' & DateCombined as key
You can associate both Tables by using Composite Key,
Project &'-'& Date as Key
How to create composite key? Using script editor or what. Can you give me step by step. Thank you
yes in the Load Script
load Field1 & '|' & Field2 as Key