DATA: LOAD ID, NAME, D, STATUS as TSTATUS FROM ....;
JOIN(DATA) LOAD ID, NAME, TSTATUS as STATUS WHERE Len(TSTATUS) > 0;
DROP Field TSTATUS;
This assumes that there is never more than one instance of ID and NAME with a status. If that is not a safe assumption, then use this for the join instead:
JOIN(DATA) LOAD ID, NAME, MaxString(TSTATUS) as STATUS WHERE Len(TSTATUS) > 0 GROUP BY ID, NAME;
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
DATA: LOAD ID, NAME, D, STATUS as TSTATUS FROM ....;
JOIN(DATA) LOAD ID, NAME, TSTATUS as STATUS WHERE Len(TSTATUS) > 0;
DROP Field TSTATUS;
This assumes that there is never more than one instance of ID and NAME with a status. If that is not a safe assumption, then use this for the join instead:
JOIN(DATA) LOAD ID, NAME, MaxString(TSTATUS) as STATUS WHERE Len(TSTATUS) > 0 GROUP BY ID, NAME;
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
