Single Column Source Data

Source have single column data, How can I get Target like row 1 goes to target 1, row 2 goes to target 2.
src :-
column_id
1
2
3
4
.
.
.
1000 ,
Target :-
Target1(1)
Target2(2)
Target3(3),
Target4(4)
.
.
Target1000(1000)
How can you achieve this scenario?

Questions by sandeep4fnds444

Showing Answers 1 - 12 of 12 Answers

Hari

  • Mar 9th, 2019
 

We can achieve using @INROWNUM system variable. @INROWNUM used to find the record count from input link.
@INROWNUM generates 1 for first record, 2 for 2nd record....

  Was this answer useful?  Yes

Arshad

  • Apr 9th, 2019
 

We can use filter stage which having single input and multiple output. And also allow multiple where conditions.
Pass the data from each condition to respective output link.
Ex. Where column_id =1 send that row to target1...

  Was this answer useful?  Yes

Rv

  • Dec 7th, 2019
 

there are thousand rows, who will write thousand different where conditions and then will configure 1000 different files, is there any other solution which dynamic?

  Was this answer useful?  Yes

Yash Ojha

  • May 9th, 2020
 

We can use the option "generate multiple files" in sequential file stage and then assign the data column as Key. SO with every change in key it will generate a new target file.

  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