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

Merge cells

Uzi
8 - Asteroid

Hi all, 

 

im trying to merge cells together like in Excel. Example given. The cells can be two or three or five.. it changing the whole time. I have read the there is a way with the formula tool or the table tool but didn't get it in that way I want

Uzi_0-1606923704429.png

thanks in advance

8 REPLIES 8
atcodedog05
22 - Nova
22 - Nova

Hi @Uzi 

 

Merge cells output is not possible to implement in Alteryx.

Uzi
8 - Asteroid

hmm is there absolutely no way to merge fields with the same content?? 

atcodedog05
22 - Nova
22 - Nova

Hi @Uzi 

 

Usual workaround is to make it out like this.

 

Output:

atcodedog05_0-1606925062114.png

Hope this helps 🙂

Uzi
8 - Asteroid

thanks a lot. That's not what i'm searching for but very good solution for someone else maybe 🙂 

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @Uzi 

 

Cheers and Happy Analyzing 😀

 

Feel free to reach out if you face any issues 🙂

KrishnaChithrathil
11 - Bolide

                     

 

Hey @atcodedog05

 

 

KrishnaChithrathil_1-1656777951252.png  can we convert to this??? remove merged cell     KrishnaChithrathil_0-1656777871865.png       

 

atcodedog05
22 - Nova
22 - Nova

Hi @KrishnaChithrathil 

 

Yes, its possible. Please post it as a new question some other solution author might be able to guide you with a solution. 

KrishnaChithrathil
11 - Bolide

 

Hey, @ atcodedog05

 

 

Yes. I've created a separate community post. Could you please look into that post?

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Work-around-with-merged-cell-in-Altery...

 

 

Thanks & Regards,

Krishna 

Labels