If condition not matched, select all data

[lzhang775]

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?

[binuacs]

@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? 

[binuacs]

@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...

[binuacs · Accepted solution]

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

[lzhang775]

Thank you, i will use this way.:)