Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

data Model issue

I gt six tables,

hav linked thm with a common key, also i hav created a calender for linking all the respective dates

but whn i try to link it with the calender table loop gets generated,

Hw to avoid tht loop, and hw can i link all the dates thn..

Please share some suggestions, hav attached the structure of the tables in attached file,

5 Replies
sivarajs
Specialist II
Specialist II

Most of the fields are common in your table just use concatenate to avoid the loop

Not applicable
Author

Thanks Sivaraj for responding,

but the client is interfering in the data model he wants no concatenation, wants a common calender also

let me knw some logic to solve this.

Not applicable
Author

anybody pls respond.....

vikasmahajan

Hii,

You can use link tables insted of concatenate I am attaching you sample demo for the same

create keys and link table.

Hope this help you

vikas

Also request you to send all excels so that we can help you.

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Not applicable
Author

Thanks for helping, i used the same concept but not the composite primary keys,

will do with tht approach later, first will deliver the output to the user..

Thanks