If condition not matched, select all data

Hi experts,

I am in a situation, source data with Company 1 and Company 2. I need to create 3 output tables, one is for company 1, one is for company 2 and one is for both 1 and 2. Is there a way I can get 3 tables at the same time without manually change filter?

Workflow

Accepted answers

binu_acs

@lzhang775 why don't you try like the below to take the total of each company id

Company select.yxmd

All comments

binu_acs

@lzhang775 use a union tool and combine the true and false anchor of the filter tool for your third requirement

lzhang775

thank you, Binuacs, this is definitely a good solution. if not other choice, i will use this one for sure. please allow me give my true situation. I have multiple input files, and analysis behind each input. Any idea to filter them all at once?

binu_acs

@lzhang775 seeing the workflow it would be very difficult to say anything, Can you provide some input files and the expected output results?

lzhang775

Hi Binuacs, thank you for replying this post. please find my simplified sample. The summary tools in container are all the same, in my real case, this step is very complicated, so we cannot change summary calculation in container. I'm looking for another way, by macro or filter after Data combination join tool, can automatically calculate by each company and then if not filter condition matched, calculate all data as one. Thinking about that I may have hundreds of companies...

Company select.yxmd

binu_acs

@lzhang775 why don't you try like the below to take the total of each company id

Company select.yxmd

lzhang775

Thank you, i will use this way.:)

Quick Links

This months top contributors

AkimasaKajitani 388

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335