Hi Designers,
Can you provide me the solution to get the name column as Row headers.It should be like
id,fullname,birthcountry,motivation,year,birthdate
1,wilhelm conrad,Germany,"in recog",1901,null
2 ............................
3...............
Hi @vkumarhit
Please find the expected output.
Edit: Do the sorting as per your need
Sort based on the ID column
Use select tool to rearrange the columns
Something like this,
Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.
If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!
Many thanks
Shanker V
Have checked with little extensive dataset.
If you need to reflect the null() in the output.
Added the filter tool to achieve the result.
And if we want to give first row as header and segment it?
As per the input shared, I have used the same as header in the workflow too.
Hope it helps!!!!
use the dynamic rename tool to make first row as header
Expecting the result like this?
I just want to separate the columns and group it by id
You need this as solution as guess
but you should not use this for exam purpose.
Definitely no !! I am using it for learning purpose 🙂
Fair
