rendered report with header/footer- naming the sheet

[DharmaAcharya]

Hello Everyone!

i am fairly new to alteryx and trying to explore the ways not to use Macros. In the attached flow, i am trying to name the excel sheet something else other than "Sheet1". When i group the 'Path', it only gives me the either one of the report (header/footer/or base report). when i add sheetname in 'path' (with "...xlsx|||myworksheet" ) it gives me pipe error.

I need header and footer on this report as well as sheetname (not 'sheet1').

any suggestion helps me to move forward.

--Dharma

[gautiergodard · Accepted solution]

Hey @DharmaAcharya 

I believe the attached solution is what you are looking for.

Hope this helps! Let me know if you have any other questions. 

[DharmaAcharya]

You are awesome! That is exactly what i was looking for. Did not much research on the 2 options for header and footer.