Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Repeating a process multiple Times

Amit
6 - Meteoroid

Hi, So let me explain the problem, i have an input dataset that looks like this 

 

Date ID

Sales

7/10/2015 5544 1.2
8/10/2015 5544 1.4
9/10/2015 5544 5.4
7/10/2015 5545 5.4
8/10/2015 5545 6.3
9/10/2015 5545 9.2
7/10/2015 5546 8.7
8/10/2015 5546 7.5
9/10/2015 5546 3.4

 

Now , I have created a workflow which uses the filter tool that selects the sales value for ID=5544 and does time series analysis on the sales using ETS and ARIMA and then uses TS Compare to generate a table showing the output of TS Compare which I am exporting to a csv file

 

I have tried to create a macro to automate this process such that I do not have to manually use the filter tool to select ID=5544 and the macro automatically selects all the ID's and repeats the process for each of them and gives me different outputs but I am not able to get the desired result.

 

Can someone help me here to get the desired result

 

 

3 REPLIES 3
mbarone
16 - Nebula
16 - Nebula

I do this sort of thing all the time - it's very useful.

 

First, you create a batch macro that filters and outputs for each ID.  Then you take that batch macro and use it in a module.  The module you use it in has a list of your IDs that you feed to that macro.

 

See attached batch macro and module.

Amit
6 - Meteoroid

Thank you so much , it really saved me a lot of time!!

mbarone
16 - Nebula
16 - Nebula

You're welcome!

Labels