Forum Discussion
CSV values
Hi Dramus,
I was able to solve the issue but its doesn't turn out to be what I was expecting. I use the unpivot but result is somehow the same with splitting a column into multiple rows instead of column. And also I had to do this with other column does it mean each column with CSV on it I had to create a new data source?
TootsiePatootsiI mentioned you at the start of the thread, you have to split it to rows and eventually that is what unpivot did.
Regarding you have to create it for each column, it all depends what you are trying to do and what is the end goal. For now, solution was provided to get you the answer for your question but if there is something more required, list the full table columns and desired end result, it will help to provide you the best solution.