https://community.qlik.com/t5/QlikView/Exclude-ID-s-with-a-specific-value-in-Load-Statement/m-p/1696597#M725058 <P>Try this,&nbsp;</P><P>Data:<BR />LOAD * INLINE [<BR />ID, Rank, Sub<BR />1, A, 23434<BR />1, B, 4546<BR />1, C, 5675<BR />2, B, 34234<BR />2, C, 546456<BR />3, A, 78686<BR />3, B, 3523523<BR />3, C, 68685<BR />3, D, 35354<BR />4, B, 57568<BR />5, B, 3242<BR />5, C, 7878<BR />5, D, 35325<BR />6, A, 56756<BR />6, B, 87979<BR />7, B, 789703<BR />7, C, 354367<BR />7, D, 7979<BR />7, E, 46546<BR />];</P><P>Filter:<BR />Load ID as ID_to_Filter<BR />Resident Data where Rank ='A';</P><P>Output:<BR />NoConcatenate<BR />Load * Resident Data where not Exists(ID_to_Filter,ID);</P><P>Drop table Data,Filter;</P> Fri, 24 Apr 2020 18:23:37 GMT kaushiknsolanki 2020-04-24T18:23:37Z https://community.qlik.com/t5/QlikView/Exclude-ID-s-with-a-specific-value-in-Load-Statement/m-p/1696577#M725057 <P>Exclude ID's with a specific value (A)in Load Statement</P><P>LOAD * INLINE [<BR />ID, Rank, Sub<BR />1, A, 23434<BR />1, B, 4546<BR />1, C, 5675<BR />2, B, 34234<BR />2, C, 546456<BR />3, A, 78686<BR />3, B, 3523523<BR />3, C, 68685<BR />3, D, 35354<BR />4, B, 57568<BR />5, B, 3242<BR />5, C, 7878<BR />5, D, 35325<BR />6, A, 56756<BR />6, B, 87979<BR />7, B, 789703<BR />7, C, 354367<BR />7, D, 7979<BR />7, E, 46546<BR />];</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.JPG" style="width: 571px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/32430i03FF64D6C4BDC6B3/image-size/large?v=v2&amp;px=999" role="button" title="Capture.JPG" alt="Capture.JPG" /></span></P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Exclude-ID-s-with-a-specific-value-in-Load-Statement/m-p/1696577#M725057 karan_kn 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Exclude-ID-s-with-a-specific-value-in-Load-Statement/m-p/1696597#M725058 <P>Try this,&nbsp;</P><P>Data:<BR />LOAD * INLINE [<BR />ID, Rank, Sub<BR />1, A, 23434<BR />1, B, 4546<BR />1, C, 5675<BR />2, B, 34234<BR />2, C, 546456<BR />3, A, 78686<BR />3, B, 3523523<BR />3, C, 68685<BR />3, D, 35354<BR />4, B, 57568<BR />5, B, 3242<BR />5, C, 7878<BR />5, D, 35325<BR />6, A, 56756<BR />6, B, 87979<BR />7, B, 789703<BR />7, C, 354367<BR />7, D, 7979<BR />7, E, 46546<BR />];</P><P>Filter:<BR />Load ID as ID_to_Filter<BR />Resident Data where Rank ='A';</P><P>Output:<BR />NoConcatenate<BR />Load * Resident Data where not Exists(ID_to_Filter,ID);</P><P>Drop table Data,Filter;</P> Fri, 24 Apr 2020 18:23:37 GMT https://community.qlik.com/t5/QlikView/Exclude-ID-s-with-a-specific-value-in-Load-Statement/m-p/1696597#M725058 kaushiknsolanki 2020-04-24T18:23:37Z