Formatting and data type conversion

mercurial_maverick

Hello all,

Attached file has "Input" and "Desired Output" tabs for your reference. I've a workflow which outputs data as in the Input tab. However I need the data to be formatted with borders, colors (for column names and rows with "total"), last 5 columns to be converted to financial information, etc. Long story short I need the Input tab to be replicated as the desired output tab. I tried to use the "Table" tool (with row rule for highlighting total row, borders, etc) and "Render" tools but unable to achieve the desired output. Please let me know how this can be done.

Example.xlsx

AngelosPachis

Hi @mercurial_maverick ,

Is this good enough?

You can edit the background colour through the default table settings, under the headers tab. To make the final row grey, i have created a row rule checking if the value under the "Total" field=="Total".

The for the final 5 fields, I have used a multi-field formula tool before the table tool.

Hope that helps, let me know if you have any questions.

Regards,

Angelos

example.yxmd