Convert 1 file into 3 files

Details:
Col
-----
C1
C2
C3
C4
C5
C6
C7
C8
C9
C10
we want to generate output like:
Col1 Col2 Col3
C1 C2 C3
C4 C5 C6
C7 C8 C9
C10
Can anyone please help me on this scenario?
  • Interview Candidate
  • 9
  • 10159

Showing Answers 1 - 9 of 9 Answers

dattu

  • Dec 26th, 2017
 

partition by round robin

  Was this answer useful?  Yes

prashant

  • Nov 25th, 2018
 

Partion by Range

  Was this answer useful?  Yes

Hemant

  • Mar 4th, 2019
 

Use below constraints in xfm to move the data into 3 different columns. Make the xfm partition to run sequential.
mod(@inrownum,3) = 1
mod(@inrownum,3) = 2
mod(@inrownum,3) = 0
This will move first record to first output file, second to second and third record to third reference link.

  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