How to handle this?

[#1]

Hi

I am loading an qvd

It contains

ID Status Time(hr)

1 Success -

2 Fail -

1 - 2

I want the result like this

ID Status Time

1 Success 2

2 Fail -

How to handle?

Can anyone help me out?

[Anonymous]

How is the data build up?? Might have to do with this ...

Seems that ID 1 with status is not correctly connected to the time in your case ...

[#3]

Something like this:

ResultTable:
Load distinct ID
Resident QvdTable;
Left join (ResultTable)
Load ID, Status
Resident QvdTable;
Left join (ResultTable)
Load ID, Time(hr) as Time
Resident QvdTable;

[johnw]

Or possibly:

LOAD
ID
,maxstring(Success) as Success
,max("Time(hr)") as Time
FROM MyQVD.qvd (QVD)
GROUP BY ID
;