Repeating a process multiple Times

[Amit]

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

[mbarone · Accepted solution]

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]

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

[mbarone]

You're welcome!