In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Count the records through the workflow

geeklarokcmie
8 - Asteroid

I need assistance on creating a creating a mechanism to track counts of  record as I compare the data.

 

Ex: Starting Count of input records is x , then using join/filter to compare data - the number records that resulted out  is z.

Compare x+z which will be used to for another comparison.

 

Thanks.

4 REPLIES 4
Matthew
11 - Bolide

all you should have to do is get a before and after count, then join the two values together

 

Matthew_0-1664226188850.png

 

carlosteixeira
15 - Aurora
15 - Aurora

Hi @geeklarokcmie 

 

Maybe you can use the Count record Tool on each exit and do another Join to compare both.

 

Thanks

Carlos A Teixeira
geeklarokcmie
8 - Asteroid

@Matthew & @carlosteixeira Thank you for the response. 

 

Join only compares between two workflows (x & z) to get the count of records which will be used for another comparison.
What if I need to have the count of records for ( a, b, x & z) to retrieve the count of records? Is there a way to do so?

Emmanuel_G
13 - Pulsar

@geeklarokcmie Did you try join multiple tool with a,b, x & z.

 

I don't know I understand well. But can you please provide some dummy input data and desired output  to test ?🙂

Labels
Top Solution Authors