Format Alteryx output

[TiboC]

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

[Qiu]

@TiboC
Maybe Table tool can do it.

Check this one first and then we can furnish your workflow further.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Table/ta-p/49555

[echuong1]

You can create the template with the reporting tools. I've created a simple example with the text and table tools, and you can format as you'd like.

[TiboC]

Hi @echuong1,

Thanks for the quick reply. This is already a big help, but some problems occur.

- The added report text occupies the entire width of the table. In reality my table is 20 columns wide which results in a misplaced layout. Is it possible to put the text only in the first column?

- 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?

Thanks In advance!

Tibo

[Accrual]

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

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.

[echuong1]

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-genera... 

[AkimasaKajitani]

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.