Hi all, My source table has 2 columns as follows 10 A 10 B 10 C 20 L 20 M 20 N 30 D 30 E In the target The data should be as follows 10 ABC 20 LMN 30 DE Any suggestions?
@Siddharth This can be done using an expression tranf and an aggregator transf. In expr declare 2 variables for ID and NAME. NAME_V IIF(ID_V=ID,NAME_V||NAME,NAME)
ID_V IIF(ID_V!=ID,ID,ID_V)
and pass the output ports to Aggregator transf GROUP BY ID. and the output of aggregator to target.... This works perfect.. Try it out..
1 comment:
@Siddharth
This can be done using an expression tranf and an aggregator transf.
In expr declare 2 variables for ID and NAME.
NAME_V
IIF(ID_V=ID,NAME_V||NAME,NAME)
ID_V
IIF(ID_V!=ID,ID,ID_V)
and pass the output ports to Aggregator transf GROUP BY ID.
and the output of aggregator to target....
This works perfect..
Try it out..
Post a Comment