Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuser222
Creator
Creator

Help with excluding rows based on few ID's??

Hi everyone,

i have a requirement where i need to exclude few rows based on ID from the external file, without hard coding the ID since they change everyday.

Please find attcahed and the script section explain my question.

Thanks

1 Solution

Accepted Solutions
jwjackso
Specialist III
Specialist III

Try a map:

Seq:

Mapping

LOAD Seq,'Y';

Load * inline [

Seq, Group

1,AAA

3,AAA

6,BBB];

Main:

LOAD ID,

           Group,

           Seq,

           Amt

           Where DelFlag = 'N';

LOAD *,

ApplyMap('Seq',Seq,'N') as DelFlag;

Load * inline [

ID, Group,Seq, Amt

1,AAA,1,100

1,AAA,2,110

1,AAA,3,800

1,AAA,4,900

2,AAA,1,200

3,BBB,1,200

3,BBB,2,200

3,BBB,6,200

3,BBB,7,200

4,CCC,8,300

5,DDD,9,300];

View solution in original post

1 Reply
jwjackso
Specialist III
Specialist III

Try a map:

Seq:

Mapping

LOAD Seq,'Y';

Load * inline [

Seq, Group

1,AAA

3,AAA

6,BBB];

Main:

LOAD ID,

           Group,

           Seq,

           Amt

           Where DelFlag = 'N';

LOAD *,

ApplyMap('Seq',Seq,'N') as DelFlag;

Load * inline [

ID, Group,Seq, Amt

1,AAA,1,100

1,AAA,2,110

1,AAA,3,800

1,AAA,4,900

2,AAA,1,200

3,BBB,1,200

3,BBB,2,200

3,BBB,6,200

3,BBB,7,200

4,CCC,8,300

5,DDD,9,300];