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: 
markgraham123
Specialist
Specialist

Separate a field name by its value

Hi all,

I have a data set below:

ID, Name

0,A

1,A

0,B

1,B

0,C

I want to load only values which has '0' in their ID but not 1.

Req: o/p:

ID, Name

0, C

Please see the attachment.

Any help is appreciated

Thanks!

1 Solution

Accepted Solutions
sunny_talwar

May be this

LOAD Name,

  ID

Where ID = 0;

LOAD Name,

  Concat(ID, ',') as ID

Group By Name;

LOAD * Inline

[

ID, Name

0,A

1,A

0,B

1,B

0,C

];

View solution in original post

3 Replies
sunny_talwar

May be this

LOAD Name,

  ID

Where ID = 0;

LOAD Name,

  Concat(ID, ',') as ID

Group By Name;

LOAD * Inline

[

ID, Name

0,A

1,A

0,B

1,B

0,C

];

annafuksa1
Creator III
Creator III

try:

table_temp:

LOAD * Inline

[

ID, Name

0,A

1,A

0,B

1,B

0,C

];

Right join

Load max(ID) as ID ,Name

Resident table_temp

group by Name;

table:

NoConcatenate

Load * Resident table_temp

where ID =0;

drop table table_temp;

markgraham123
Specialist
Specialist
Author

As usual, Perfect brother!

Thanks!