In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3

In the source seq file have 2 columns, i.e
input:
col1,col2
1,1
2,rajesh
3,15000
4,2
5,suresh
6,16000
7,3
8,veeru
9,17000

I want in the output like:
eno,ename,sal
1,rajesh,15000
2,suresh,16000
3,veeru,17000

any one answer this scenario

Question Posted / chandra_parthu

3 Answers
6609 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,sures..

Answer / subhash

SRC--->TFM--->PIVOT----> TGT

In TFM, use below logic
col1 MOD 3----->col1
then out from TFM is:
col1,col2
1,1
2,rajesh
0,15000
1,2
2,suresh
0,16000
1,3
2,veeru
0,17000
In PIVOT, do vertical PIVOT, group by column is 'col1' and pivot column is 'col2' then we will get desired output.

Is This Answer Correct ?

5 Yes

1 No

In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,sures..

Answer / subhash

SRC--->TFM--->PIVOT----> TGT

In TFM, use below logic
if col1<4 then 1 elseIf col1>3 AND col1<7 then 2 else 3-----
>col1
then out from TFM is:
col1,col2
1,1
1,rajesh
1,15000
2,2
2,suresh
2,16000
3,3
3,veeru
3,17000
In PIVOT, do vertical PIVOT, group by column is 'col1' and
pivot column is 'col2' then we will get desired output.

Is This Answer Correct ?

3 Yes

0 No

In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,sures..

Answer / bharath

if inputlnk.col1%3= 1 then outputlnk.col1=inputlnk.col2
else inputlnk.col2

if inputlnk.col1%3= 2 then outputlnk.col2=inputlnk.col2
else inputlnk.col2

if inputlnk.col1%3= 0 then outputlnk.col3=inputlnk.col2
else inputlnk.col2

use above conditions in transformer stage
and then
change the column names using modify stage
as col1 = eno
col2 = ename
col3 = sal

let me know right answer, if i'm wrong...
..

Is This Answer Correct ?

3 Yes

5 No

Post New Answer