Format Alteryx output

Question

Hi all,

Please find in the screenshot enclosed the 3 formatting questions I am having concerning the format of my alteryx output. On the left side you can see my current alteryx output. On the Right side you can see how the formatted output should look like.

A) I would need to export my alteryx output into a standard template (BoxA).

B)  The headers of my output (BoxB) should be formatted with (bold, text color, fill color & wrap text)

C) The numbers in (BoxC) should be formatted

Can someone help me with my case? Is this possible in alteryx?

Thanks in advance.

Tibo

AkimasaKajitani · Answer

Hi @TiboC

- What if I would need to add other tables to the same render output but in a different sheet? I knew how this was done with the Output data tool, but is this also possible with the render tool?

Yes!

If the data stream have "sheetname" field, Render tool output the data to each sheet.

echuong1 · Answer

For the first issue, I suggest changing the alignment to the Right rather than centered.

With regard to having multiple tables in the same output, yes this is possible. See this post for an example:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Change-Excel-sheet-name-in-file-generated-from-Render-tool/td-p/374726

Accrual · Answer

Take a look at this post: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Alteryx-Run-Command-Executing-Excel-Macros-VBA/ta-p/471551

This is the more ideal way to format the excel, reporting is ok, but its better to just code the VBA and have Alteryx execute the vba. This is what I do for a lot of reports I am generating for my current company.