How to split data from a single column based on the delimiter in datastage?
<p>i want to do the below scenario in Datastage.</p>

<p>I have source file named source.csv file like below,</p>

<h2>Code_id</h2>

<p>100</p>

<p>200</p>

<p>300</p>

<p>100,200,400</p>

<p>Now, i want to split the records in 4th row based on the delimiter(,).
The expected result should be,</p>

<h2>Code_id</h2>

<p>100</p>

<p>200</p>

<p>300</p>

<p>100</p>

<p>200</p>

<p>400</p>

<p>I have tried this by using DCOUNT, Field datastage functions. But i couldn't get exact result which i mentioned above.</p>

<p>Kindly can anyone please guide or suggest some ideas to do this?.</p>

<p>Note: I don't know the number of delimiter before processing the file.</p>