concat colmns in transformer if condition happens
Posted: Mon Nov 08, 2010 5:50 am
Hi, I am writing for advice.
In a transformer, I carry out checks on inputs, for example on the formal correctness of the dates.
I have to concatenate in a new column in output, only the values of columns that do not pass the checks I mentioned above.
I use the variables stage, but I do not know how to concatenate input columns, under a condition true / false.
I would get something like this:.
Is possible and how?!
Thank you very much
In a transformer, I carry out checks on inputs, for example on the formal correctness of the dates.
I have to concatenate in a new column in output, only the values of columns that do not pass the checks I mentioned above.
I use the variables stage, but I do not know how to concatenate input columns, under a condition true / false.
I would get something like this:
Code: Select all
stageVar = "(if check1 = 1 then col1 else'') concatenated with (if check2 = 1 Then col2 else'') concatenated with (if check3 = 3 then col3 else'') etc"
Is possible and how?!
Thank you very much