Separate a field name by its value

[markgraham123]

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!

[sunny_talwar · Accepted solution]

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]

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]

As usual, Perfect brother!

Thanks!