Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!

Alteryx Designer Discussions

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

Creating an Additional Row Header

KamenRider
8 - Asteroid

Hi and good day.

 

I would like to ask if it is possible to create another header to look like this. Output will be an excel file. Attaching the sample file.

 

KamenRider_0-1660493093703.png

 

I'm looking forward for you assistance in helping me for the solution.

 

Thanks,

Kamen

6 REPLIES 6
Amol_Telore
11 - Bolide

Hey @KamenRider 

 

Using Reporting tools we can create merged rows and merged columns. Can you provide a sample input dataset? 

KamenRider
8 - Asteroid

Hi @Amol_Telore 

 

Thanks for responding. I have attached a sample input file. Can you please show me how to do it?

 

Appreciate your response.

 

Kamen

IraWatt
16 - Nebula

Hey @KamenRider,

 

There is an Awesome blog on the steps to do this here on the community: How to Create Merged Cells in Reports, Part 2 - Alteryx Community

 

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

 

KamenRider
8 - Asteroid

Hi @IraWatt 

 

Thanks. This is a very nice tutorial however my header is a date which changes quarterly. I feel the tutorial does not fit the solution I am looking for. If you have any idea, I would appreciate it very much.

 

Please advise.

 

Kamen

IraWatt
16 - Nebula

@KamenRider what I linked explains how you will create the merged headers. To create the changing date headers is quite straight forward using the date time tools/formulas. Without knowing how your data comes in its hard to suggest just one solution.

 

There is a good Blog here: https://community.alteryx.com/t5/Engine-Works/DateTime-Functions-Cheat-Sheet/ba-p/844353 which should help you to create dynamic date headers.

KamenRider
8 - Asteroid

Hi @IraWatt 

 

I am not quite good yet with Alteryx. Is it possible to show how I to do it so I can start with it? Your assistance is very much appreciated.

 

Thanks so much,

 

Kamen

Labels