topic How to extract data from two different logical tables in a single load (In script level) in QlikView https://community.qlik.com/t5/QlikView/How-to-extract-data-from-two-different-logical-tables-in-a/m-p/208077#M1208385 <HTML><HEAD></HEAD><BODY><P>Please help me out to extract data from two or more logical tables in single load..</P><P>i have a big dought like why can't we use resident with sources supprated with any delimiter</P><P>like</P><P><STRONG>load ...</STRONG></P><P><STRONG>resident a,b,c; ???</STRONG></P><P>Please help me out..</P><P>Thankyou in advance <span class="lia-unicode-emoji" title=":slightly_smiling_face:">๐Ÿ™‚</span></P></BODY></HTML> Mon, 11 Jan 2010 07:48:26 GMT 2010-01-11T07:48:26Z How to extract data from two different logical tables in a single load (In script level) https://community.qlik.com/t5/QlikView/How-to-extract-data-from-two-different-logical-tables-in-a/m-p/208077#M1208385 <HTML><HEAD></HEAD><BODY><P>Please help me out to extract data from two or more logical tables in single load..</P><P>i have a big dought like why can't we use resident with sources supprated with any delimiter</P><P>like</P><P><STRONG>load ...</STRONG></P><P><STRONG>resident a,b,c; ???</STRONG></P><P>Please help me out..</P><P>Thankyou in advance <span class="lia-unicode-emoji" title=":slightly_smiling_face:">๐Ÿ™‚</span></P></BODY></HTML> Mon, 11 Jan 2010 07:48:26 GMT https://community.qlik.com/t5/QlikView/How-to-extract-data-from-two-different-logical-tables-in-a/m-p/208077#M1208385 2010-01-11T07:48:26Z How to extract data from two different logical tables in a single load (In script level) https://community.qlik.com/t5/QlikView/How-to-extract-data-from-two-different-logical-tables-in-a/m-p/208078#M1208386 <HTML><HEAD></HEAD><BODY><P>Each resident load can just pull data from one target table.</P><P>If you're trying to pull fields with the same names from the different tables you can use a for loop:</P><P>for each Test in 'A', 'B', 'C'<BR />load<BR /> FieldX</P><P>resident '$(Test)';<BR />next</P></BODY></HTML> Mon, 11 Jan 2010 08:02:07 GMT https://community.qlik.com/t5/QlikView/How-to-extract-data-from-two-different-logical-tables-in-a/m-p/208078#M1208386 Anonymous 2010-01-11T08:02:07Z How to extract data from two different logical tables in a single load (In script level) https://community.qlik.com/t5/QlikView/How-to-extract-data-from-two-different-logical-tables-in-a/m-p/208079#M1208387 <HTML><HEAD></HEAD><BODY><P>thankyou Johannes Sundรฉn ,but in case of different fields what would be the better solution..please let me know if you have any solution for this <span class="lia-unicode-emoji" title=":slightly_smiling_face:">๐Ÿ™‚</span></P><P></P></BODY></HTML> Mon, 11 Jan 2010 08:57:23 GMT https://community.qlik.com/t5/QlikView/How-to-extract-data-from-two-different-logical-tables-in-a/m-p/208079#M1208387 2010-01-11T08:57:23Z How to extract data from two different logical tables in a single load (In script level) https://community.qlik.com/t5/QlikView/How-to-extract-data-from-two-different-logical-tables-in-a/m-p/208080#M1208388 <HTML><HEAD></HEAD><BODY><P>First I would ask myself why I need them in one table. I'm sure there might be good reasons for it though but you would have to set up different load statements for the different tables and then join them over keyfields to create your joined table. You can't query several tables in one load statement.</P></BODY></HTML> Mon, 11 Jan 2010 09:37:09 GMT https://community.qlik.com/t5/QlikView/How-to-extract-data-from-two-different-logical-tables-in-a/m-p/208080#M1208388 Anonymous 2010-01-11T09:37:09Z