How to map column members in Talend

[Anonymous]

Hi, I have a scenario where I have to map column members from input to output. I.e.

ABC (Source_Column)	ABC1 (Target_Column)
Plan	Actual Plan
Billed	To be Billed
	Waived
To Be Billed	To Be Billed

So what I mean is, for my ABC column if the member is "Plan", in the ABC1, the member should be called as "Actual Plan". If 'Billed', then in ABC1 as To be billed etc. How can I do it..? Is there any good link/tutorial that goes over how to build this logic. Pls help, thanks!

[vboppudi]

Hi KanT,

You can try below approach to get desired output.

in tMap: for Target column logic will be 

row2.Details == null || row2.Details=="" ? "Waived":row2.Details.equals("Plan")?"Actual Plan":row2.Details.equals("Billed")?"To be Billed":row2.Details 

Regards,