I am looking to convert all values from 1 columns to one single value in Informatica.
Col1
Row1 A
Row2 B
Row3 C
Row4 D
To
Col 1
Row1 A,B,C,D
I have the the input available from an expression. Thank you!
I am looking to convert all values from 1 columns to one single value in Informatica.
Col1
Row1 A
Row2 B
Row3 C
Row4 D
To
Col 1
Row1 A,B,C,D
I have the the input available from an expression. Thank you!
It should be possible to do it using a variable port in Expression transformation.
E.g.
After the Expression transformation, use an Aggregator transformation to pass only the last row which will have the concatenated value.
I have not tested it. Let me know if this works.