Link tables and mapping

[Zirva]

I have multiple tables coming from different sources with different granularity. They have some common fields like city, region etc for which I have made a key and am using the link table concept. the keys are this way: 

Load
ProductName&'-'&ProjectName&'-'&RegionArName&'-'&CityArName&'-'&Year&'-'&Month as key,
....
From[Source 1]

Load

RegionArName&'-'&CityArName&'-'&SalaryRange&'-'&Year&'-'&Month as key,
......
From[Source 2]

LOAD
ProductName&'-'&ProjectName&'-'&RegionArName&'-'&CityArName&'-'&SalaryRange&'-'&Year&'-'&Month as key,
....
From[Source 3]

This created a link table from which Im using RegionArName, CityArName, ProjectName as filters across the dashboard. My issue is that the city filter is working fine but Region and Project filters are not, such that each projectname is showing mapping against multiple regions which is not the case at the backend. What am I doing wrong?

[anat]

Key from source1 is combination of 6 fields, 

Key from source2 is combination of 5 fields,

Key from source3 is combination of 8 fields, 

Key should be created base on common fields in the all sources

[MatheusC]

Hi, @Zirva 
As mentioned by @anat , the key fields are different between tables, so this will not produce the expected result.
Review your data model; Perhaps you can create a mapping or joins of the tables, it will depend on how your data is structured for this, before creating the link keys to bring the same results between them.

https://community.qlik.com/t5/Brasil/Diferen%C3%A7a-entra-mapping-load-e-Join/td-p/1223598

Adjusting your scenario in the script, choose to use the function autonumberhash128 instead of these multiple concatenated fields.

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/CounterFunctio...


Regarts, Matheus