Table Formating in Alteryx

[SH_94]

Hi Community,

I would like to seek for help about the table formatting issue in Alteryx. Currently i rendered out the table as per screenshot below but some of the details are being truncated. For instance , the table should show >360 and Amount instead of >36 and Amou respectively. May I know how we need to fix the table format so that it will capture complete information as per alteryx.

Secondly, i would like to render the results below under one excel file with different sheet name for each tab. May i know how can we build the workflow in Alteryx so that it will presented in one file but under different tab?

Many thanks for your help.

[SH_94]

Hi @Sntrada ,

Thanks a lot for your help. I able to generate the excel file with different table in the different tabs.

Appreciate your help and advice on the sheetname.

Thank you.

[SH_94]

Hi @Sntrada ,

May i know if we can build the workflow in Alteryx for insert the link as per screenshot below and adjust the second table lower with the Header of the table.

I had included the original file and after amendment file ( which i would like to build in Alteryx) for your reference. Not sure if we able to build it in the Alteryx.

[Sntrada]

Hi Jacob, 

This isn't exactly like your target format-wise, but it does have the table header and hyperlink. 

Hope it helps, and let me know if you have questions. 

p.s, I am rendering it as a temp file, be sure to change this if you want the output saved. 

[SH_94]

Hi @Sntrada ,

Good day to you.

I had tried to run the workflow and export it to the excel file format but it appear as the below error. The only things that i had amended is as per the second screenshot.It is because i need to choose the header as layout to prevent the error coming out after running the workflow.

[Sntrada · Accepted solution]

Please uncheck the header box. 

I previously tried to use the header tool to make the title appear, but this seems to only work for PDF files. 

The amended workflow is attached. 

[SH_94]

Hi @Sntrada ,

It is really amazing after i analysis the workflow on how you build it and i able to make the same for my result. However, there are few things that i would like to clarify with you:

1. May i know how can i make the first header to become left aligned?

2.Secondly , i would like to make the first row and the first column empty as below with the limited size . Is it possible that we can amend it in the Alteryx?

Many thanks again for your workflow as it really helps a lot.

[Sntrada]

Hi Jacob

For your first question, this can be achieved by setting the alignment of that column to left. You can do this in the table configuration dialogue box. 

After setting the alignment to left, it looks like the image below.

I don't know of a way to add that initial extra row and column space in Alteryx. But you can easily have some VBA code to reformat the tables in Excel however you'll like them to look.