if statement help

[apthansh]

Hi , I have my data as below

ID   Status        Type     Amount

1     Active        Active    234

1    Complete   Active     440

2    Active        Active     333

3    Complete   Active     220

Here If Status is Active and Complete I want ID with Active to be picked else everything else.I want the output as below.

ID   Status        Type     Amount

1     Active        Active    234

2    Active        Active     333

3    Complete   Active     220

Thanks much.

[sunny_talwar]

Try this

Table:

LOAD * INLINE [

    ID, Status, Type, Amount

    1, Active, Active, 234

    1, Complete, Active, 440

    2, Active, Active, 333

    3, Complete, Active, 220

];

Right Join (Table)

LOAD ID,

MinString(Status) as Status

Resident Table

Group By ID;

[Anil_Babu_Samineni]

Script or Front end? May be this in script?

Right Join

LOAD ID,

MinString(Status) as Status

Resident Table

Group By ID;

[sunny_talwar]

We think a like

[Anil_Babu_Samineni]

But, Late as always