Group a Column using Table tool

Mark191919

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

hhaigh1

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. 

Merge Table Cells.yxmd