how to remove the loops in database structure - Qlik Community

Report Inappropriate Content · ‎2016-08-03

Hi Friends,

I'm pulling 30 qvd's while loading the qvd it takes more time because of synthetic keys is there any way to remove, one method is to rename but it is not practical in my case is there any method to eliminate that,

1.how to use concatenate?how its works?

2.One or more loops have been detected in the database structure ?(Attached the screenshot)

3.Data-model should be like a star scheme how to make effectively ?

Please comment all your suggestions

Thank you

Sooraj J

Anil_Babu_Samineni · ‎2016-08-03

From this What are you expecting? You want Answers for these Questions?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Mark_Little · ‎2016-08-03

Hi,

Can you supply some more information?

If all the qvd's contain the same data or mostly the same fields then you want to concatenate them together. What it does ids creates one table, Add the data from each QVD to the bottom of the last one loaded.

Mark