Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Report - Column Merge

suby
11 - Bolide

Hi All,

 

  • I'm trying to recreate the  atcodedog solution from the below post.

https://community.alteryx.com/t5/Engine-Works/How-to-Create-Merged-Cells-in-Reports-Part-2/ba-p/9787...

 

 

when I tried to add a new container in the workflow by adding two two extra columns in the new container.

 

The city header is not aligned with the new columns APAC & EMEA.

 

Could you please help where the issue is.

 

I'm attaching the workflow  as per atcodedog solutions.

7 REPLIES 7
Raj
16 - Nebula

@suby 
this is been updated
mark done if solved.

binuacs
21 - Polaris

@suby it works if you change the order in the join tool

 

image.png

suby
11 - Bolide

Hi Raj,

 

Thanks can you tell us where you made the changes ? I can see you have increased the Fixed size to 7 other than that any other changes you made it to work?

 

Or is it just you added the to the Join Multiple tool.

 

Thanks

suby
11 - Bolide

Hi Binuacs,

 

Thanks say if I want to have the CITY as the Last header not in the Middle how this can be done.

 

Why this get miss aligned is there a reason for that technically this should work.

 

Could you please have a look to see how we can get this displayed as a last column rather than in middle.

 

Also if you have solution please let me know where you made the changes.

 

In my real scenario  I have the same issue that when we change the order it works.

 

 

suby
11 - Bolide

Hi Raj,

 

I tested it but CITY column should hold only APAC and EMEA.

 

But in when I opened the PDF and PPT  output I get this form your solution.

 

Do you know why?Output.PNG

Raj
16 - Nebula

@suby 
i have added a green container to show how this is done 
once you create such layout for all the groups combine them horizontally using layout tool and you will have a solution.

hope this is clear now.

Raj
16 - Nebula

@suby 
all the Green portion is added and this will work for any format

Mark solutions done if solved.

Labels
Top Solution Authors