Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

Filter by a field and create seperate report

Highlighted
7 - Meteor

Hi all,

 

I have a data in excel with 30 columns one of them is salesperson and region. I want to create a dynamic filter by salesperson name and base on this generate seperate report for each of salesperson name and send the email to them automatically.

On the top of that, i would like to depend on the region field to filter seperate report by region and send to manager (a region have many salesperson)

I found some batch macro in the forum and tested them out but they dont work as I want... i think because the macro works differently when i use input from an excel file?

 

Can anyone advise if it can be achieve and how to do it? Very appreciate your help

 

Highlighted
11 - Bolide
11 - Bolide

for the reports, use the group functions - it will pass through the values in the output:

jarrod_0-1585236576214.png

 

then you can create a lookup table off to the side of which user get's which reports. you'll likely need a separate stream for the users and managers since those will be rolled up at different levels of granularity. 

Highlighted
7 - Meteor

So you mean i dont need to use a macro batch filter to filter the name and create report seperately? I think the macro batch would work better. I tried the report and group be the salesperson but it will have all the person there. How can i send each salesperson report to his/her individual name? 

Highlighted
11 - Bolide
11 - Bolide

You can absolutely user a batch macro in this instance, but it will likely be simpler if you batch the reports and send to your list of emails. You can control the report distribution per email address you send to. I have a process now that sends individual reports to account managers and subscribers all in a single process without any batch macros. I'll mock something up here shortly for your case.

Highlighted
7 - Meteor

Thank you so much... my concern is the information is sensitive so my thought of batch macro filter is to ensure the data can be received by dedicated person... but unfortunately, non of the batch macro i tried work for excel file filter on column ... i will test out your workflow and fingercross for it to works.

 

Thank you again

Highlighted
11 - Bolide
11 - Bolide

absolutely want to make sure you aren't sending to the wrong people

 

See my attached example workflow:

jarrod_0-1585241182107.png

basically, if you have the permissions per store/region, you can just join those to the groups of reports and send out a single email to all of those that have the permission. (see the summarize tool for grouping emails). you can get fancy with it as well if you want CC or BCC for certain reports. let me know if this doesn't work for you. The input file is the sample database from the alteryx install, so that file path should be good if it's installed in the default directory. 

Labels