my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data:

my source has 2 columns. 1st column data: ABC ABC ABC XYZ
and 2nd column data: 1 2 3 4. And my target should be ABC 1 2
3, XYZ 4

Question Posted / rakeshm4119@gmail.com

2 Answers
6208 Views
Zensar, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my tar..

Answer / shiva

col1 col2 COL1 COL2
ABC 1 ABC 1,2,3
ABC 2 XYZ 4
ABC 3
XYZ 4

S-SQ-AGG-SORT-TGT

IN AGG TAKE 4 VARIABLE PORTS

1)V_COL1 (in this write) v_cur_col1
2)v_cur_col1 (in this write) col1
3)flag (in this) iff(col1=v_col1,1,0)
4)v_col2 (in this ) decode(flag=1,v_col2||,||col2,col2
5)o_col2 (in this) v_col2 (this is a o/p port)

Is This Answer Correct ?

8 Yes

3 No

my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my tar..

Answer / moorthy g

S-->SQ-->EXP-->AGG--->TGT
EXP:
Create Variable port:

res: decode(col1=prev_col1,concat(res,col2), col2)
O_put: res
pre_col1=col1

AGG:
group by col1

Is This Answer Correct ?

2 Yes

1 No

Post New Answer