Break down of data in one row into multiple rows

[varunreddy]

Hi All,

I am trying to break data from one row and display them as different rows.

In the above mentioned examples, for ID - 2, I have 3 countries. Now I want to display each country in each row.

I am looking to achieve this:

Can anyone came across this situation?

Thanks,

Varun

[sunny_talwar · Accepted solution]

Check this link out:

The Secret Life of SubField

May be like this

LOAD ID,

           SubField(Countries, Chr(10)) as Country

FROM ....

or

LOAD ID,

           SubField(Countries, Chr(13)) as Country

FROM ....

[varunreddy]

Sunny,

Thanks for your quick response!