Hi - I'm currently working on a reconciliation using Alteryx and I need to split the input line item file into separate files based on a column value so I can reconcile them separately. Example column to split based on values - (source ledger has 3 different values; receivables, payables and spreadsheet).The current process I was thinking of was using multiple filter tools and wanted to check if there is a better way of doing it as I'd like to build a process pipeline that can be run across multiple files to be reconciled.
