Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
d_ankusha
Contributor II

Data association issue

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.

Labels (2)
1 Solution

Accepted Solutions
passionate
Valued Contributor

Re: Data association issue

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

4 Replies
passionate
Valued Contributor

Re: Data association issue

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

d_ankusha
Contributor II

Re: Data association issue

Can you suggest how to do that?
passionate
Valued Contributor

Re: Data association issue

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
Honored Contributor

Re: Data association issue

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.
HirisH
“Aspire to Inspire before we Expire!”