How to export the data by each category

Question

Dear Community,

May i know how can i export the excel data below by producing each file based on the manager name?

For instance, ask the alteryx to extract those line related to Manager : Loo and save the file name as Loo.This process repeat for all the other manager as well and save it individually.

Thank you.

Checking file.xlsx

ArtApa · Accepted Answer

Hi @SH_94 -  You just need to create a field for your XLSX file name and configure the Output Data tool:

mtouiti · Accepted Answer

Also, in case you are using the Render tool to generate your Excel with specific formatting you can find that option on the configuration window :

Best

Mo