Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $400 before Dec 31st: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
d_ankusha
Creator II
Creator 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
Specialist
Specialist

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

View solution in original post

4 Replies
passionate
Specialist
Specialist

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

d_ankusha
Creator II
Creator II
Author

Can you suggest how to do that?
passionate
Specialist
Specialist

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
Master
Master

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!”