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.
We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!
How to add header by merging several cells
I'm currently working on the issue about adding a header for my excel sheet using Alteryx, certain cells should be merged (A1 to B3), can anyone help me with it ? Thank you so much.
Need to convert sheet 1 to sheet 2 by Alteryx. The test excel has been attached.
Excel sheet 1
Excel sheet 2
Go to Solution.
Go to Solution.
@Paddi The below post by @atcodedog05 will be helpful for your use case
If I understand your requirement correctly,
You will have the inputs in sheet 1 and the output with header needs to be saved in the same input file but in Sheet 2.
1. Here is the solution to you
Step 1: Add the input tool and input the file.
Step 2: Add Block Until Done tool from Developer tab, this will enable to overwrite on the same input file.
If this tool is not used, it will not allow to save the output on the same file.
Step 3: Add the Output tool, select the Sheet 2 as to save the output.
This will resolve your problem.
Hope my solution helps to resolve your issue.
And for your second requirement to merge the cells, you can refer the response from my friend @binuacs
Let me know if you need any more assistance in this.
@Paddi One way of adding the header using the Report Text Tool
Thanks Binuacs, it solved most of my problem.
Thanks Shanker, I'm actually not facing the block issue in Alteryx, but thank you for your kind advice anyway.