Render tool - File name and sheet name

Hi there,

I need some help to combine two input sources and create a report through Render tool; the file name is coming from two input file names and sheet names are also different based. I am good with render, but template option may be good, but the header needs a date and hence Template won't work for me.

Right now i have challenges to getting two sheets with two different names combined into one file name and can anyone help me.

Alteryx Combine SHeet query.png

Workflow

Accepted answers

All comments

alexnajm

It's hard to help with just a screenshot of the workflow but hopefully this helps: Solved: Render to multiple tabs in 1 excel file - Alteryx Community

Raj_2

It is useful to some extend, but my issue is file name is dynamic and it should be picked up from the input source, like different countries etc. This then should combine to one output file with two tabs.

I also attached a sample work flow, if you could see and help me, i need France with sheet names ABC/DEF sheets and similarly Japan with two sheets in it. THanks in advance for the help.

Sample.yxmd

alexnajm

You aren't selecting File Name in the Render! Make sure you select it as a group in the Layout and use it in your Render

Raj_2

Thanks, yes that helped me, but i have below issues.

Render (133) The current page layout has caused some data to be incorrectly truncated and the Excel file to be corrupted. We recommend modifying how the data is laid out.

2) Need to add heading and header tool to accomodate logo

Thanks again for the support.

Raj_2

Any other options?

alexnajm

@Raj_2 I ran the same flow with my changes and I did not see any of the errors you are seeing - if you changed other things from what you sent, we'll need that as well

apathetichell

1 is page size --- change it to a larger size like 30X 30 or 17X17... render is designed to fit to a specific page.

2--- that's your job... go through training on render tools and learn how to use the report header.

Raj_2

The work flow i shared is sample only, when i adjusted the page size the excel error is gone, but report header is what i am trying to fix now

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335