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