Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop 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