This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I've got a table that gets output to Excel but I need to add a "Header". I can't use the Header tool. I need the text to show in Cell A1 (not just show up in the Print Preview) and I need the table to move down a few lines to accommodate that. I've been playing around with the Reporting Tools with no luck. I've tried the Report Text Tool selecting "Attach text to existing field" and position the text above the existing object but when I do that all I get is a new column and a [no valid field] in the configuration of the tool.
@cmcclellan sorry to bother, your solution worked perfectly, but it happened to me that after adding a new input (the header), my output got the sheet order flipped. My Alteryx has a "Block until done" tool in the middle of the process, when I added the header, the resulting output got my sheet 1 in the end of the excel output file. I tried adding more "Block until done" tools and reverting the order of the outputs but without success.
As you can see on the image, the "Detail" output sheet should be the last one, but no matter how I order the output or where I put the block tool, it ends up showing first.