Data association issue

[d_ankusha]

Hi All ,

I have a datamodel which is based on star schema. In the Fact table there are two fields named: Office ID and Pickup date. Now I have to add another table to the data model which contains Office ID and Pickup date field. The problem here is that in Fact Table there are some pickup dates where not all offices are present . But in new table all the dates have all offices values in them. So when I am trying to directly associate them  , either dates go missing or offices have invalid values. 

Please someone suggest a workaround for this requirement.

[passionate · Accepted solution]

This is best suited for use of link table between fact and the other table.

[d_ankusha]

Can you suggest how to do that?

[passionate]

It basically created using Autonumber or autonumberhash256 function creation a key in fact and table.

the load all common field along with autonumber key in table.

you can get many article to create link table in qlik and it's quite simple to create.

refer below link for reference:

http://www.learnallbi.com/link-table-in-qlikview/

[HirisH_V7]

My Suggestion is to create a apply map for current and new table. Bring all those dates & even find out which were unmapped.

Here, first validation should be done on the data, beside keeping into a model or other.