Render tool - File name and sheet name

[Raj_2]

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.

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

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

1) 

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