topic Separate a field name by its value in QlikView

Separate a field name by its value

markgraham123 — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Separate a field name by its value

sunny_talwar — Thu, 16 Mar 2017 12:36:26 GMT

May be this

LOAD Name,

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

];

Re: Separate a field name by its value

annafuksa1 — Thu, 16 Mar 2017 12:39:25 GMT

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;

Re: Separate a field name by its value

markgraham123 — Thu, 16 Mar 2017 12:44:08 GMT

As usual, Perfect brother!

Thanks!