Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Check this link out:
May be like this
LOAD ID,
SubField(Countries, Chr(10)) as Country
FROM ....
or
LOAD ID,
SubField(Countries, Chr(13)) as Country
FROM ....
Check this link out:
May be like this
LOAD ID,
SubField(Countries, Chr(10)) as Country
FROM ....
or
LOAD ID,
SubField(Countries, Chr(13)) as Country
FROM ....
Sunny,
Thanks for your quick response!