DSXchange

Hi All,

Can any one explain,How to use 2 else statements in if-then-else statements in transformer stage.

reqrmnt is:

if columnA='DSX' then populate col1,else col2,else col3.

can any one please help me on this..

You can't have two 'else' statements in a single expression. Of course, you can have multiple else statements in multiple in-line expressions but each only has two halves. One 'if' and one 'else' per.

If you need to populate three different columns, simply use three appropriate expressions, one in each derivation.

Hi Chullet,

Thanks for the reply,

And my reqrment is like:

if the value of the ColumnA = 'dsx' then populate TARCOL1,Else populate TARCOL2.if this column values is also null then populate TARCOL3.

I know - I see now you already have a post on this very subject. Starting a second does nothing but cause unnecessart double-work.

Please use your original post to continue this conversation.

Sure and I mentioned clearly now about my reqrmnt in my original post..

thanks

Nothing about your requirement is clear or you'd have an answer by now. Let's stay back in your first post.