Conditional Excel Column Mapping

I want to transform data in the following way:

1) I read a column from my reader (input)
2) when the value is not null (string) then load the data in the designated writer field
3) when the value is null (empty string) then load the data from another input field

How can I do this?
Sean

Hi Sean

This can be easily achieved by using "If Null Or Empty String"  transformation function.

www.etl-tools.com/wiki/advanced-etl-proc...ull-or-empty-string/

We will create a working example for you and post it here.

It should be ready by the end of the day.

Hi Sean

Please see the attached working example

 

 

And some screenshots.




 

Thank you, I will give it a try