topic Re: how to remove the loops in database structure in QlikView https://community.qlik.com/t5/QlikView/how-to-remove-the-loops-in-database-structure/m-p/1118180#M895628 <HTML><HEAD></HEAD><BODY><P>From this What are you expecting? You want Answers for these Questions?</P></BODY></HTML> Wed, 03 Aug 2016 12:49:20 GMT Anil_Babu_Samineni 2016-08-03T12:49:20Z how to remove the loops in database structure https://community.qlik.com/t5/QlikView/how-to-remove-the-loops-in-database-structure/m-p/1118179#M895627 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: verdana, geneva;">Hi Friends,</SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;">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, </SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;">1.how to use concatenate?how its works?</SPAN></P><P><SPAN style="font-family: verdana, geneva;">2.One or more loops have been detected in the database structure ?(Attached the screenshot)</SPAN></P><P><SPAN style="font-family: verdana, geneva;">3.Data-model should be like a star scheme how to make effectively ? </SPAN></P><P><SPAN style="font-family: verdana, geneva;">Please comment&nbsp; all your suggestions</SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;">Thank you</SPAN></P><P><SPAN style="font-family: verdana, geneva;">Sooraj J</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/how-to-remove-the-loops-in-database-structure/m-p/1118179#M895627 2020-11-25T16:16:04Z Re: how to remove the loops in database structure https://community.qlik.com/t5/QlikView/how-to-remove-the-loops-in-database-structure/m-p/1118180#M895628 <HTML><HEAD></HEAD><BODY><P>From this What are you expecting? You want Answers for these Questions?</P></BODY></HTML> Wed, 03 Aug 2016 12:49:20 GMT https://community.qlik.com/t5/QlikView/how-to-remove-the-loops-in-database-structure/m-p/1118180#M895628 Anil_Babu_Samineni 2016-08-03T12:49:20Z Re: how to remove the loops in database structure https://community.qlik.com/t5/QlikView/how-to-remove-the-loops-in-database-structure/m-p/1118181#M895629 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can you supply some more information?</P><P>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.</P><P></P><P>Mark</P></BODY></HTML> Wed, 03 Aug 2016 12:54:24 GMT https://community.qlik.com/t5/QlikView/how-to-remove-the-loops-in-database-structure/m-p/1118181#M895629 Mark_Little 2016-08-03T12:54:24Z