split output

[SouravKayal]

So i have an excel sheet with 10 tabs or different sheets. I want to output exact same format of 10 sheets but based on a value of another column unique values. So there is a name field in the data. I want to split each file by the number of unique names so that all filters on each sheet are for that particular name only.

[caltang]

@DataNath 's article is pretty good: https://community.alteryx.com/t5/Engine-Works/How-to-Render-to-Multiple-Named-Excel-Sheets/ba-p/1015...

[Xervarian]

using a render output: I am getting a desired result save for 1 item: 

using the PDF to Text tool from the intelligence suite, extrapolating multiple PDF's to output in excel, I am getting data conflated in 1 excel output from 2 different pdfs. 

1 file to 1 excel splitting on the file name, im trying to figure that out

150	FILE 1-PASSTHRU-ADV	9	47
323	FILE 2-PASSTHRU-ADV	9	48