Split table by field value and then email split tables

[KMiller]

Hi

Is Alteryx able to do the following:

1. Split a table into separate files by field value i.e. email addresses or staff name. There a large number of values and they will change over time therefore I need to automate this process as opposed to using multiple filters.
2. Once I have individual tables for each relevant staff member, I want to email each of them their table for review. Again given the number of staff involved, I need this to be automated.

Not sure if I am expecting too much here.

Thanks in advance for any help.

Kevin

[LordNeilLord · Accepted solution]

Hey @KMiller

If you have the relevant email address in your table you can use the grouping tool in the table tool.....

And this field can now be used in the email tool:

[KMiller]

Thanks for the help, that was really straightforward.