DSXchange

my input is like :

C1 C2
--- ------
123 ABC;DEF;GEH

Output :


C1 C2 C3 C4
--- ------ ----- --------
123 ABC DEF GEH


Thanks in advance

first you need to let us know if the number of columns on which the data of C2 needs to divided, is fixed.

And ; is the delimiter on which it needs to be divided. Use of some plain English words to describe the situation will also help.

yes, ';' is the delimiter to divide the column and also C2 is not fixed length.

Please do not come here and simply post input and output examples and ask for "logic to implement". Explain to us in words what your requirements are, what needs to be done to turn the input data into the output data. Ideally, also add what you've tried so far and what issues you have had trying to get that to work.

We're here to help people and are obviously happy to do so but we're not a service where you drop off your work then come back and pick it up later. So please help us help you by providing the above information.

I'd also be curious what exact 8.x version of DataStage you are running.

Looks like a task for a Column Import stage.

Except for the "C2 is not fixed length" part... I was thinking that Transformer Looping might be the way to go, hence the version question.

One could use a Column Import stage with sufficient target columns.

There's no convenient way to use looping to populate an arbitrary number of target columns unless, again, you have at least sufficient target columns.

I am using DataStage 8.7 version...

In which case all of the above advice is apposite.