Converting single row into multiple columns with number of rows only
Hi Guys,
I want to convert a single row data into multiple columns by limiting the number of rows. Lets say for example I have 20 rows data and I want to convert first 5 rows as a single column and next 5 rows as another column. The column does not have any delimiter like "|" , ";" or of any sort. Also only one column is present so couldnt use tpivottocolumn or tdenormalize.
Does anybody know how to do so? Would appreciate the help.
If your source is file based, you may want to explore the Multi schema approach, which may help you achieve the desired output. Additionally if you can give some sample data to support your ask it may help anyone to help you.
