Group a Column using Table tool
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Guys,
Need help. I was trying to create a workflow that will send an information via email for my QA purposes. So basically what I need to do is to send me a table layout that look like this
However, what I want is to show only one value (Filename column) for what ever value that are the same for that field. So it is the same as merging a cell or column when it comes on excel file. I was trying to figure out that on the table tool but didn't get any chance to do that.
Thanks in advance
Solved! Go to Solution.
- Labels:
- Common Use Cases
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Mark191919
The table tool doesn't have an option to merge cells like you can in excel. That would be a great feature though, you should submit an idea for that on our forum!
I came up with a workaround using multiple table tools that ends up with a table that looks very similar to what you have in excel:
The trick was to create multiple tables.
First, I created a table for Count, QA, and Status and grouped that by FileName. Then I created a table with two columns: FileName and the table created in Step1. I used a layout tool to merge the two together (making sure to select "Vertical Merge Contents to Line Up Table Columns" as the orientation). That duplicated header rows though, so I deselected header rows and created another table that would function as the header row and merged that in as well.
Also see the attached workflow.
Technical Product Manager - Data Connectors
Alteryx, Inc.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @HenrietteH
I'm trying to open the workflow file that you attached in your post but I am using an older version of Alteryx and my organization resricts Alteryx users to using version 11.0.3.25674. Is there any way you could upload the same workflow created in an older version of Alteryx so that I can open the file?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @HenrietteH
Thank you for giving me a solution on this. This really help me to do what I want on my module. I will submit this and hoping it will be added on future updates. Thank you :-)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here you go @user_km. The attached workflow should work for you.
Technical Product Manager - Data Connectors
Alteryx, Inc.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
We have to merge couple of columns as per the attached example. Tried all possible combinations in the canvas provided by you. Didn’t work. Could you please help.
Thanks in advance
Nag
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @nagsrini
You can repeat the process of nesting tables multiple times. In your example you would nest one more table as described above.
First table: Issue + Total
Second table: Issue Type + first table
Third table: File name + second table
Everything else would be as described above.
Technical Product Manager - Data Connectors
Alteryx, Inc.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Worked perfectly well. Thanks a lot.