Merge Two Columns into One Column in Target

I have a file having columns C1,C2,C3,C4,C5 with comma delimited.In target I want store the first two columns value into one column.
Like below
Input Output I need
-------------- ----------------------
C1 C2 C3 C4 C5 C1(C1 & C2 value) C3 C4 C5
That means my input is 5 columns & Output will be 4 columns.
Can anyone suggest how Can I achieve this in DS job ?

Questions by Aloka   answers by Aloka

Showing Answers 1 - 2 of 2 Answers


  • Aug 26th, 2016

You can try using copy & tx stages

  Was this answer useful?  Yes


  • Aug 26th, 2016

Create a new stage variable and using concatenation operator combine first two columns data and map it to a column.

  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