Logic needed

[apthansh]

Hi,

Below is my data structure

ID   Status                     Amt

1    Active                       234

1    Completed                211

2    Active                       2000

3    Completed                400

If ID has Active and Completed count only ID with Active else count other status...

I want the below output

ID   Status                     Amt

1    Active                       234

2    Active                       2000

3    Completed                400

Thank you much.

[prma7799]

Like this you want

[shiveshsingh]

i.e for ID = 1 you want only Active to be loaded as status in script?

Do you have any reference date column also?

[apthansh]

This out put has 2 rows for ID 1..I only want Active ID if its both Active and Completed.