Hello All,
I am once again looking to this fantastic community for help.
My organisation has a records inventory which includes boxes of records. Each box has a box number and then the records within that box have a record number.
I have utilised Alteryx to mass apply retention codes to the records via key word searches.
Following this I am now looking to gather an overview of which boxes have had retention codes applied to all records, and the ones which do not have codes applied to all records, I want to identify how many records are "blank" in the retention code field within each box.
Thanks,
Dan
Solved! Go to Solution.
Assuming your Retention Code fields are Null rather than just blank there's a summarize option to do that.
If they're blank rather than Null you'll need a formula step to adjust that first and then you can do the same thing.
Data fed into that to show what it is doing:
Thank you Scott.