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 1 | 60 | 40 | 0 |
Filter 2 | 45 | 15 | 15 |
Join 1 | 50 | 10 | 0 |
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
@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?