Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Aligning merged cells with their appropriate row values

VinithaNair
7 - Meteor

I have a use case where I need to merge all holders pertaining to a ticker in one cell as well as align their manager names across that particular holder (screenshots attached). The issue occurs when I concatenate values in the summarize tool (highlighted in blue). The output just concatenates all the manager names without aligning them to their respective holders. A method I tried, was to just add a formula tool and replace all null spaces under Manager1 with "   " (three spaces in between). However, I'm guessing this is not the most efficient way of solving the problem. Would be great to know if there is a work around for this with my existing workflow in place?

 

Thanks!

1 REPLY 1
aatalai
15 - Aurora

@VinithaNair look at the multi row tool that could help

Labels
Top Solution Authors