We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.
SOLVED

How to add header by merging several cells

Paddi
8 - Asteroid

How to add header by merging several cells

 

Hi,

 

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.

 

Paddi_1-1667799564725.png

Excel sheet 1

 

Paddi_0-1667799541662.png

Excel sheet 2

6 REPLIES 6
binuacs
17 - Castor
ShankerV
13 - Pulsar

Hi @Paddi 

 

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.

 

Many thanks

Shanker V

ShankerV
13 - Pulsar

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.

 

binuacs
17 - Castor

@Paddi One way of adding the header using the Report Text Tool

 

binuacs_0-1667806833605.png

 

Paddi
8 - Asteroid

Thanks Binuacs, it solved most of my problem.

Paddi
8 - Asteroid

Thanks Shanker,  I'm actually not facing the block issue in Alteryx, but thank you for your kind advice anyway.

Labels