Alteryx Designer Desktop Discussions

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

Table of records being selected and excluded (filtering)

smallpotato
7 - Meteor

Hi I have used lots of filter tools in my alteryx workflow.

I would like to have a table to mark down the number of records being selected and excluded by the filter true/false function and the join tool.

Table as below:

Tool# of Selected Records# of Excluded Records# of Duplicated Records
Filter 160400
Filter 2451515
Join 150100

I used the join tool to duplicate some of the records, and hope it could be count in the last column.

Im looking of ways to create an extra summary table like this by using the summarize tool, while not affecting the original workflow.

also wanna know if there is way to rename the first column

for example, "filter 1" renamed as "filter for ABC purpose"

"filter 2" renamed as "filter for BCD purpose"

for easier recognition

1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

@smallpotato 
Would it be acceptable that you collect the data from Results window after running the flow then use another workflow to parse data to get the summary you want?

Or you can enable to logging to collect the data?

2024-03-06 130934.png

Labels