In my source table I have two columns

[Geek_Guest]

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

[N SRIRAM K]

Question wasn't clear

[arasanrajkumar]

Dear Friend,

Could you please more specific with your question? Because the question is not very clear.

[tanya_j]

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