Decoding value in transformer
Posted: Thu Jan 08, 2009 2:21 am
Hi All
I have a scenario here
Input :
Col 1, Col 2, Col 3
=============
1, abc, 123
1, abc, 123
1, abc, 456
2, def, 111
2, def, 112
Output :
Col 1, Col 2, Col 3
=============
1, abc, 1
1, abc, 2
1, abc, 3
2, def, 1
2, def, 2
Can please suggest how can I do this using stage variables ?
my source and targets are flat files.
Thanks in advance
Suresh
I have a scenario here
Input :
Col 1, Col 2, Col 3
=============
1, abc, 123
1, abc, 123
1, abc, 456
2, def, 111
2, def, 112
Output :
Col 1, Col 2, Col 3
=============
1, abc, 1
1, abc, 2
1, abc, 3
2, def, 1
2, def, 2
Can please suggest how can I do this using stage variables ?
my source and targets are flat files.
Thanks in advance
Suresh