DataStage Scenario - Problem9

Goal : Distribute the data is below requirement

Input file's data is distributed like 1st 3 row in file1, next 3 row in file2, next 3 rows in file3 again next 3 rows in file1 and continues.

FileA
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
OutPut
File1	File2	File3
1	4	7
2	5	8
3	6	9
10	13	16
11	14
12	15