I have a requirement where in one column I am getting certain values for different records. I have to extract this column and convert the values into rows.
For e.g My record is as: -
Code: Select all
AD|BANK OPS|255068|1098765|BC|46E;654;87R
Code: Select all
46E
654
87R
The number of ";" seperated values for different records may change and are dynamic. In DS Server 7.5, since there is no Pivot stage, can anyone please help and suggest how to do this?