topic Re: Load with a condition in QlikView https://community.qlik.com/t5/QlikView/Load-with-a-condition/m-p/888118#M657405 <HTML><HEAD></HEAD><BODY><P>YASSER TRY THIS</P><P>Fact:</P><P>LOAD </P><P>id,</P><P>xyz;</P><P>...from fact;</P><P></P><P>--many tables in between these tables has id fields</P><P></P><P>SalesPerson:</P><P>LOAD id,</P><P>SalesPerson, from ...</P><P><STRONG>Where Exists(id)</STRONG>;</P></BODY></HTML> Tue, 19 May 2015 13:17:24 GMT 2015-05-19T13:17:24Z Load with a condition https://community.qlik.com/t5/QlikView/Load-with-a-condition/m-p/888115#M657402 <HTML><HEAD></HEAD><BODY><P>Hello to all,</P><P></P><P>I have two tables I want to load in my script. I load Table1 first, with an ID field. I want to load for the Table2 only lines with an ID that existe in the Table1.</P><P></P><P></P><P></P><P>How to do so?</P><P></P><P>Thank you !</P></BODY></HTML> Tue, 19 May 2015 13:12:08 GMT https://community.qlik.com/t5/QlikView/Load-with-a-condition/m-p/888115#M657402 2015-05-19T13:12:08Z Re: Load with a condition https://community.qlik.com/t5/QlikView/Load-with-a-condition/m-p/888116#M657403 <HTML><HEAD></HEAD><BODY><P>Table1:</P><P>LOAD ID, .... FROM Table1....;</P><P></P><P>Concatenate</P><P>LOAD ID, ....</P><P>FROM Table2 ....</P><P>WHERE Exists(ID)</P></BODY></HTML> Tue, 19 May 2015 13:14:47 GMT https://community.qlik.com/t5/QlikView/Load-with-a-condition/m-p/888116#M657403 jonathandienst 2015-05-19T13:14:47Z Re: Load with a condition https://community.qlik.com/t5/QlikView/Load-with-a-condition/m-p/888117#M657404 <HTML><HEAD></HEAD><BODY><P>LOAD ID,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ...</P><P>FROM Table2</P><P><STRONG>WHERE EXISTS(ID)</STRONG>;</P></BODY></HTML> Tue, 19 May 2015 13:14:58 GMT https://community.qlik.com/t5/QlikView/Load-with-a-condition/m-p/888117#M657404 swuehl 2015-05-19T13:14:58Z Re: Load with a condition https://community.qlik.com/t5/QlikView/Load-with-a-condition/m-p/888118#M657405 <HTML><HEAD></HEAD><BODY><P>YASSER TRY THIS</P><P>Fact:</P><P>LOAD </P><P>id,</P><P>xyz;</P><P>...from fact;</P><P></P><P>--many tables in between these tables has id fields</P><P></P><P>SalesPerson:</P><P>LOAD id,</P><P>SalesPerson, from ...</P><P><STRONG>Where Exists(id)</STRONG>;</P></BODY></HTML> Tue, 19 May 2015 13:17:24 GMT https://community.qlik.com/t5/QlikView/Load-with-a-condition/m-p/888118#M657405 2015-05-19T13:17:24Z Re: Load with a condition https://community.qlik.com/t5/QlikView/Load-with-a-condition/m-p/888119#M657406 <HTML><HEAD></HEAD><BODY><P>LOAD </P><P>&nbsp;&nbsp;&nbsp;&nbsp; ID</P><P>From Table1;</P><P></P><P>Left Join</P><P></P><P style="font-size: 13.3333330154419px;">LOAD </P><P style="font-size: 13.3333330154419px;">&nbsp;&nbsp;&nbsp;&nbsp; ID</P><P style="font-size: 13.3333330154419px;">From Table2;</P></BODY></HTML> Tue, 19 May 2015 13:18:02 GMT https://community.qlik.com/t5/QlikView/Load-with-a-condition/m-p/888119#M657406 ToniKautto 2015-05-19T13:18:02Z Re: Load with a condition https://community.qlik.com/t5/QlikView/Load-with-a-condition/m-p/888120#M657407 <HTML><HEAD></HEAD><BODY><P>thank you</P></BODY></HTML> Tue, 19 May 2015 13:43:19 GMT https://community.qlik.com/t5/QlikView/Load-with-a-condition/m-p/888120#M657407 2015-05-19T13:43:19Z Re: Load with a condition https://community.qlik.com/t5/QlikView/Load-with-a-condition/m-p/888121#M657408 <HTML><HEAD></HEAD><BODY><P>thank you for the answer, it worked</P></BODY></HTML> Tue, 19 May 2015 13:44:01 GMT https://community.qlik.com/t5/QlikView/Load-with-a-condition/m-p/888121#M657408 2015-05-19T13:44:01Z Re: Load with a condition https://community.qlik.com/t5/QlikView/Load-with-a-condition/m-p/888122#M657409 <HTML><HEAD></HEAD><BODY><P>Thank you for the accurate answer, it's working</P></BODY></HTML> Tue, 19 May 2015 13:45:28 GMT https://community.qlik.com/t5/QlikView/Load-with-a-condition/m-p/888122#M657409 2015-05-19T13:45:28Z Re: Load with a condition https://community.qlik.com/t5/QlikView/Load-with-a-condition/m-p/888123#M657410 <HTML><HEAD></HEAD><BODY><P>welcome sir</P></BODY></HTML> Wed, 20 May 2015 05:34:28 GMT https://community.qlik.com/t5/QlikView/Load-with-a-condition/m-p/888123#M657410 2015-05-20T05:34:28Z