Filtering and Unioning, not getting correct count

[wonka1234]

Hi,

When I filter my dataset I am getting the correct count, however when I union the columns together it is not the right count.

Does anyone know why my count has gone up so high? Shouldnt it be the same as my previous summary? 

How do I join these together without adding extra rows?

[StephaneP]

Hello @wonka1234 ,

From what I understand from your pictures, the 202 rows are the sum of the rows from your 1st top filter. Which is the #1 input of your Union tool. It only count the numbers of row of this 1st filter, not of the 7 others.
Then you have several other filters (meaning more rows, tens, hundreds...) that you all consolidate using a UNION tool. There is the previous #1 input but also many others #2, #3... up to #8 at least.

This Union tool seems to display 606 rows.

If the others inputs of your union tools (#2, #3...) are bringing rows then it is normal that it is higher than 202. It will be 202 + #2 rows +#3 rows +...

Am I missing anything ?

[wonka1234]

@StephaneP 

Your right, Forget the summary and union.

Can I add my filter outputs to one column only?

[StephaneP]

Hello,

can you give a small example/explanation of what you are trying to achieve?

I am not sure to understand the question « add to one column only ».

thx