topic LOAD data to DB in QlikView https://community.qlik.com/t5/QlikView/LOAD-data-to-DB/m-p/357368#M702751 <HTML><HEAD></HEAD><BODY><P><SPAN id="result_box" lang="en"><SPAN class="hps">I'm</SPAN> <SPAN class="hps">uploading</SPAN> <SPAN class="hps">my</SPAN> <SPAN class="hps">data base for</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps atn">'</SPAN><SPAN>application</SPAN> <SPAN class="hps">QW</SPAN><SPAN>,</SPAN> <SPAN class="hps">I have two</SPAN> <SPAN class="hps">problems</SPAN><SPAN>:</SPAN><BR /> <SPAN class="hps">1)</SPAN> <SPAN class="hps">I have a table</SPAN> <SPAN class="hps">that has two</SPAN> <SPAN class="hps">FK</SPAN> <SPAN class="hps">table</SPAN> <SPAN class="hps">another table</SPAN> <SPAN class="hps">how can I</SPAN> <SPAN class="hps">upload data to</SPAN> <SPAN class="hps">avoid</SPAN> <SPAN class="hps">cyclic references</SPAN><SPAN>?</SPAN><SPAN>,</SPAN> <SPAN class="hps atn">'</SPAN><SPAN>Only solution is</SPAN> <SPAN class="hps">to replicate the</SPAN> <SPAN class="hps">table</SPAN> <SPAN class="hps">but since the</SPAN> <SPAN class="hps">table</SPAN> <SPAN class="hps">has</SPAN> <SPAN class="hps">to be replicated</SPAN> <SPAN class="hps">as if</SPAN> <SPAN class="hps">duplicassi</SPAN> <SPAN class="hps">other</SPAN> <SPAN class="hps">FK is</SPAN> <SPAN class="hps">part of the</SPAN> <SPAN class="hps">DB</SPAN><SPAN>.</SPAN><BR /> <SPAN class="hps">2)</SPAN> <SPAN class="hps">As</SPAN> <SPAN class="hps">QW</SPAN><SPAN>'s</SPAN> <SPAN class="hps">boots</SPAN> <SPAN class="hps">are translated</SPAN> <SPAN class="hps">sel_join</SPAN><SPAN>,</SPAN> <SPAN class="hps">I always have</SPAN> <SPAN class="hps">to duplicate data</SPAN><SPAN>?</SPAN></SPAN></P><P></P><P></P><P><SPAN id="result_box" lang="en"><SPAN class="hps">In</SPAN> <SPAN class="hps">attachment</SPAN> <SPAN class="hps">scripts</SPAN> <SPAN class="hps">delegate</SPAN> <SPAN class="hps">tables</SPAN> <SPAN class="hps">that refer</SPAN> <SPAN class="hps">to Case 1</SPAN></SPAN></P></BODY></HTML> Wed, 18 Jul 2012 16:05:37 GMT 2012-07-18T16:05:37Z LOAD data to DB https://community.qlik.com/t5/QlikView/LOAD-data-to-DB/m-p/357368#M702751 <HTML><HEAD></HEAD><BODY><P><SPAN id="result_box" lang="en"><SPAN class="hps">I'm</SPAN> <SPAN class="hps">uploading</SPAN> <SPAN class="hps">my</SPAN> <SPAN class="hps">data base for</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps atn">'</SPAN><SPAN>application</SPAN> <SPAN class="hps">QW</SPAN><SPAN>,</SPAN> <SPAN class="hps">I have two</SPAN> <SPAN class="hps">problems</SPAN><SPAN>:</SPAN><BR /> <SPAN class="hps">1)</SPAN> <SPAN class="hps">I have a table</SPAN> <SPAN class="hps">that has two</SPAN> <SPAN class="hps">FK</SPAN> <SPAN class="hps">table</SPAN> <SPAN class="hps">another table</SPAN> <SPAN class="hps">how can I</SPAN> <SPAN class="hps">upload data to</SPAN> <SPAN class="hps">avoid</SPAN> <SPAN class="hps">cyclic references</SPAN><SPAN>?</SPAN><SPAN>,</SPAN> <SPAN class="hps atn">'</SPAN><SPAN>Only solution is</SPAN> <SPAN class="hps">to replicate the</SPAN> <SPAN class="hps">table</SPAN> <SPAN class="hps">but since the</SPAN> <SPAN class="hps">table</SPAN> <SPAN class="hps">has</SPAN> <SPAN class="hps">to be replicated</SPAN> <SPAN class="hps">as if</SPAN> <SPAN class="hps">duplicassi</SPAN> <SPAN class="hps">other</SPAN> <SPAN class="hps">FK is</SPAN> <SPAN class="hps">part of the</SPAN> <SPAN class="hps">DB</SPAN><SPAN>.</SPAN><BR /> <SPAN class="hps">2)</SPAN> <SPAN class="hps">As</SPAN> <SPAN class="hps">QW</SPAN><SPAN>'s</SPAN> <SPAN class="hps">boots</SPAN> <SPAN class="hps">are translated</SPAN> <SPAN class="hps">sel_join</SPAN><SPAN>,</SPAN> <SPAN class="hps">I always have</SPAN> <SPAN class="hps">to duplicate data</SPAN><SPAN>?</SPAN></SPAN></P><P></P><P></P><P><SPAN id="result_box" lang="en"><SPAN class="hps">In</SPAN> <SPAN class="hps">attachment</SPAN> <SPAN class="hps">scripts</SPAN> <SPAN class="hps">delegate</SPAN> <SPAN class="hps">tables</SPAN> <SPAN class="hps">that refer</SPAN> <SPAN class="hps">to Case 1</SPAN></SPAN></P></BODY></HTML> Wed, 18 Jul 2012 16:05:37 GMT https://community.qlik.com/t5/QlikView/LOAD-data-to-DB/m-p/357368#M702751 2012-07-18T16:05:37Z