Filter report table by cell color

I have a sample workflow that appends a transactions file with a contracts file and then highlights the transaction cells green or red based on if they match the contents of the contracts file. What I would like to do is now separate the rows that are all green meaning all of the transactions match all of the contracts from the ones with red meaning they are not a 100% match.

Any help would be greatly appreciated.

Sample Workflow.yxmd

Reporting

Custom Tools

Help

Accepted answers

Hi @Travis_Ratliff

If i understood weel, it is something like this right:

Sample Workflowv2.yxmd

All comments

Hi @Travis_Ratliff

When you say separate, do you want them outputted to a separate table?

Hi @Travis_Ratliff

If i understood weel, it is something like this right:

Sample Workflowv2.yxmd

Yes, however, you are separating the tables before making them I was wondering if there is a way to separate them after making the table.

Yes, @CarliE I would like them to be two separate tables so that when I use my render tool I can put them on two different worksheets.

As far as i now, after you turn the dataset into a report table, it is impossible to separate them.

But why you dont just separate them before and assign each one to a different sheet?

@Felipe_Ribeir0 I had not even considered doing that until you mentioned it so I thank you because you saved me a lot of time and steps.

Quick Links

Tags

This months top contributors

AkimasaKajitani 387

Hollingsworth 335