Split data files based on a column value

[PeggyGithinji]

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. 

[Luke_C]

Hi @PeggyGithinji 

This article should be exactly what you need: https://knowledge.alteryx.com/index/s/article/Output-to-separate-Excel-files-1583459117188