condition based dimension in script

[viveksingh]

HI Experts,

I have a data like below

if you observe in the above, Description have different values. Based on a particular value(Failed)  all the values of description should be Failed for ABC01 value else it should be Success. 

Below is the expected for reference

 

I want to derive in load script. Please share your comments. 

Thanks in advance. 

[Marcos_rv]

try this:
MAIN:
load
name, description
from MAIN.QVD;

aux_1:
LOAD
name ,
if ( wildmatch(aux , 'Failed' ) > 0 ) , 'Failed' , 'Success' ) status_1;
LOAD name , concat(description) as aux
resident main
GROUP BY name ;

left join (MAIN)
load name , status_1 as status
resident aux_1;
drop table aux_1;

saludos!!!

[viveksingh]

Thanks for the reply. But this is not working as expected. 

Can help to provide another type of solution/work around please. 

[Brett_Bleess]

Vivek, you would need to use Group by or Order by in the load and then use the Peek() function I believe to check for that string and if you hit it, then 'map' the other status values all to Failed at that point, but I am afraid I cannot code this for you, only point you in the right direction.  Someone else may still chime in though, as my comment will kick things back up in the list again, so maybe someone else will be able to share some code, but you could also search prior posts, as I am pretty sure you will find some examples out there that will help you get things right on this one, as this is fairly comment scenario.  Sorry I do not have better for you.

Regards,
Brett

[Arthur_Fong]

In load script:

Data:

load *, if(Name='ABC 01','Failed','Success')as Status

resident <YourTableName>;

drop table <YourTableName>;