topic Re: Repeating a process multiple Times in Alteryx Designer Desktop Discussions

Repeating a process multiple Times

Amit — Thu, 24 May 2018 01:31:00 GMT

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

Re: Repeating a process multiple Times

mbarone — Thu, 10 Dec 2015 15:01:20 GMT

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.

Re: Repeating a process multiple Times

Amit — Fri, 11 Dec 2015 08:27:08 GMT

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

Re: Repeating a process multiple Times

mbarone — Fri, 11 Dec 2015 12:02:23 GMT

You're welcome!