Highlighting 1st row and Export as Table

Hello! I am working on a report where I need to highlight the header in Green and Font color as White. I was able to do this using the table tool thru updating the header settings. However, if I do this, my output returns to a 1 liner text as per attached.

can you help me solve these?

In addition, how do I add another sheet with blank data? So basically there should be 2 sheets. The 1st one is with the data based on my workflow the second one should be blank but with sheet name “Formula”. Thank you.

B13215D4-FD39-4142-9830-9AB79D288D31.jpeg

Macros

Accepted answers

LukeG

@Jhayeanne012

It appears that the render tool is writing out to a temporary excel file. I believe this should be a specific output file.

The final output tool that shows the error in your screenshot should also point to the same specific output file.

As long as both of those conditions are met and the file is not open anywhere on your computer it should allow you to write the output.

Please let me know if there are any other issues that come up. Happy to continue troubleshooting until we find a solution.

-Luke

All comments

LukeG

@Jhayeanne012

Here is a solution that should...

1. output your table with the formatting you created

2. Create another sheet titled "Formula" with no data

The Render tool allows you to output the table you created.

The Block Until Done tool allows that output to finish before creating the empty sheet. This helps to avoid errors.

With the final Output, be sure that you are creating an new sheet and skipping field names.

Please let me know if you have any questions! Happy to help!

MultiSheet Output.yxmd

Jhayeanne012

Hi Luke,

Thank you for taking time in helping me. Our company version of Alteryx is still 2018.4.4 and it seems there are functions you have used that I am missing. Nevertheless, I have updated my workflow following yours, but I still get errors as attached.

The output table should go to sheet "Fails" and the empty sheet goes to sheet "Formula"

Apologies, I caan attached my workflow due to data confidentiality but I have attached a screenshot of my workflow. Thanks again and appreciate if you can help me further.

2020-07-09_15-53-16.png

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703