Transformer

I am having input--> I want Output like-->
slno|Name slno|Name
1|X 1|X
2|Y 2|X
3|Z 2|X
3|Z
3|Z
3|Z

Showing Answers 1 - 2 of 2 Answers

Sirisha d

  • Apr 18th, 2017
 

Considering the input data is below.
slno|Name
1|X
2|Y
3|Z
desired output is
slno|Name slno|Name
1|X 1|X
2|Y 2|X
3|Z 2|X
In the transformer output link add a new column called Name_slno along with the two input columns.
Give derivation as Name: :slno for the column Name_slno .
Then rearrange the column order.

  Was this answer useful?  Yes

Sirisha d

  • Sep 12th, 2017
 

Considering the input data is below.
slno|Name
1|X
2|Y
3|Z
desired output is
slno|Name slno|Name
1|X 1|X
2|Y 2|Y
3|Z 3|Z
In the transformer output link add a new column called Name_slno along with the two input columns.
Give derivation as Name: :slno for the column Name_slno .

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions