In my source table I have two columns, there values like
1 A1 B1 C2 G2 H2 I3 L3 M
I want to get in target like this...
1 A*B*C2 G*H*I3 L*M
Please anyone can solve this...
Thanks in advance...
Question asked by visitor Haritha
In my source table I have two columns, there values like
1 A1 B1 C2 G2 H2 I3 L3 M
I want to get in target like this...
1 A*B*C2 G*H*I3 L*M
Please anyone can solve this...
Thanks in advance...
Question asked by visitor Haritha
Question wasn't clear
Thx
SRIRAM N
Hope Everything Good
Dear Friend,
Could you please more specific with your question? Because the question is not very clear.
Hi,
If im not mistaken ur qn is
Src
1 A
1 B
1 C
2 G
2 H
2 I
3 L
3 M
I want to get in target like this...
1 A*B*C
2 G*H*I
3 L*M
U can designate the column names as ID and NAME.
Use an expression transformation.Declare two variables for ID and NAME.
ie NAME_V PORT use the expression
IIF(ID_V=ID,NAME_V||'*'||NAME,NAME)
ID_V PORT
IIF(ID_V!=ID,ID,ID_V)
Next pass these ports to an aggregator transformation and do GROUP BY ID.
Then pass to target..
Try this ..It will work perfect...
Regards
Tanya