Formating an output table

achint_kumar
achint_kumar New Altair Community Member
edited November 5 in Community Q&A
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. :)

Tagged:

Best Answer

  • varunm1
    varunm1 New Altair Community Member
    edited March 2020 Answer ✓
    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.. 

Answers

  • [Deleted User]
    [Deleted User] New Altair Community Member
    edited March 2020
    @achint_kumar

    Hello

    Could you please send your data?  :)

    Thank you
    mbs
  • achint_kumar
    achint_kumar New Altair Community Member
    edited March 2020
    I'm not able to attach the file, maybe because i'm using office laptop, is it possible for you to make a dummy data like that & get the solution? Looking forward to hearing from you.
  • varunm1
    varunm1 New Altair Community Member
    edited March 2020 Answer ✓
    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.. 
  • achint_kumar
    achint_kumar New Altair Community Member
    @mbs
    Thank you it works very well. :)