Options
Formating an output table
achint_kumar
Member Posts: 16 
Contributor II
in Help
Hi Everyone,
I have processed a summary table using RM. I need the below formatting:
1) to convert my FIRST ROW in attached data to COLUMN HEADER.
2) To convert "id" to an actual column and arrange it in first row of excel as it currently write in the end column of an excel.
To be converted into below output excel:
Looking forward to hearing from you.
I have processed a summary table using RM. I need the below formatting:
1) to convert my FIRST ROW in attached data to COLUMN HEADER.
2) To convert "id" to an actual column and arrange it in first row of excel as it currently write in the end column of an excel.
To be converted into below output excel:
Looking forward to hearing from you.
0
Best Answer
-
Options
varunm1
Moderator, Member Posts: 1,207 
Unicorn
Hello @achint_kumar
You need to use the "Rename by example value" operator to set the first row in row number option as your column header.
For question 2, I guess try removing the special role of this column using "set role" operator and selecting regular as the type for id column. Then try using the "reorder attributes" operator to order the attributes as you wish and then use write excel operator..Regards,
Varun
https://www.varunmandalapu.com/Be Safe. Follow precautions and Maintain Social Distancing
6
Answers
Hello
Could you please send your data?
Thank you
mbs
Thank you it works very well.