Add another association

[Anonymous]

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

[ali_hijazi]

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

[shraddha_g]

You can associate both Tables by using Composite Key,

Project &'-'& Date as Key

[Anonymous]

How to create composite key? Using script editor or what. Can you give me step by step. Thank you

[shraddha_g]

Refer https://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/

[ali_hijazi]

yes in the Load Script

load Field1 & '|' & Field2 as Key