Forum Discussion
Split column data into unique columns based on its datatype and populate column with Value data.
Hello, I am sharing a small dataset on the left which I am struggling to achieve the desired output shown on the table to the right. Can anyone assist?
Follow the below steps
select column type , from transform tab, pick add prefix from the format comand and write "Type" as value in the oppened window to reach the next image
then select type column and go to the transform tab and pick pivot command and provide the next settingthen press ok to reach your desired table as
4 Replies
Don't do it. Load the data as is and let the Matrix visual sort out the pivoting for you.
Nate,
That worked like magic!
THANK YOU!
Farid
Follow the below steps
select column type , from transform tab, pick add prefix from the format comand and write "Type" as value in the oppened window to reach the next image
then select type column and go to the transform tab and pick pivot command and provide the next settingthen press ok to reach your desired table as
