In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Column Merge

Sarath27
8 - Asteroid

Hi All,

 

I am trying to merge columns similar to excel.

 

Pls find the attachment for your reference both screenshot & excel file and kindly help me achieving this.

5 REPLIES 5
caltang
17 - Castor
17 - Castor

Like so:

 

image.png

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Sarath27
8 - Asteroid

Thanks much. I need to have a blank column after every grand total. i.e after 2023_07_31_Grand_Total there should be a blank column where next date should start.

caltang
17 - Castor
17 - Castor

You can add a column by using the Formula tool and title it as "Blank". Then use a Select tool to put some space between them.

 

If you have multiple, then you can add a row in te cross-tab/transpose section I did. 

 

Try it out and let me know. If you're stuck, I'll show you how. The clues above should teach you.

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Sarath27
8 - Asteroid

I am kind of confused of where I should add formula tool, pls assist me on this.

caltang
17 - Castor
17 - Castor

Try this. One of many ways.

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Labels
Top Solution Authors