How to perform Conditional Loop and run the workflow for certain conditions?

[madhurinani]

Hello,

Below is my input file.

Group	Cost	Balance Left
A	1	6
A	2	8
A	3	3
A	4	4
B	5	6
B	6	1
B	7	3
B	8	9
C	9	3
C	10	6
C	11	2
D	12	3
D	13	1

Now, I want to run the workflow for Group A and store the output in an excel file GroupA.xlsx

Then the workflow should again run for Group B and store the output in an excel file GroupB.xlsx

and so forth.

Is it possible? I tried to use the Condition interface tool as well as the Macro Input tool but somehow ran into a dead end.

Also, is it possible to run the workflow for All Group values (A-->D) at once and also provide a drop down option for the user to run either A/B/C/D?

Your help would be highly appreciated.

Thanks

[JamesCharnley · Accepted solution]

To run all groups at once and allow the user to choose which group they 'want to see' as such, that's a good use case for an analytic app. You'd set it up as follows:

A summarise tool grouping on group twice, and the cross-tab tool will give you one column for each possible group, to feed into a drop down tool for your app.

In the action tool, you're choosing which group you want to replace in the condition of your filter. This will allow only the records for the group you want through.

As for your other question about different outputs, the best way to do that would be with a filter tool, filtering to groups and attaching outputs to each one.

[madhurinani]

@JamesCharnley :

Hi,

I tried to run the Analytics App and somehow its not working for me.

I added a new formula and stored the output in an excel file, while everything remains the same.

When I run, and select any group, it defaults to A only.

Am i missing something?

[JamesCharnley]

 @madhurinani Sorry, I didn't set up the interface designer. You'll want to open up the interface designer under View > Interface Designer and tick whatever you want to be able to see as the output. In your case, you'll want to tick the output tool. In my case it's the browse.

When you run this as an analytic app with the magic wand button next to run, it should be working.

[madhurinani]

@JamesCharnley : Your solution of using a Filter tool to filter the groups and store in different outputs files will only work if i have 1-2 groups. I might have 10+ groups and having so many filter tools might not be an ideal solution.

[Christina_H]

You don't need a filter to create multiple output files, just use the option in the output tool to take the file name from a field.  If you use a formula to create the different file names, a single output tool will write the data to the correct files.

[madhurinani]

@JamesCharnley : You have used the Drop Down tool which only allows for a single group to be selected. 

I tried to change to a check box which would enable to choose either 1 or multiple. But somehow I am unable to get that fixed.

Would you be able to guide me ?

Thanks

[JamesCharnley · Accepted solution]

@madhurinani  Sorry for the delay in response. If you haven't managed to fix this by now here's how it's done:

Instead of having the [Group] in your filter '=' something, you'll want to use IN to allow for multiple conditions to be changed in one action.

Then instead of the drop down you'll want a list box. You'll want to change the settings on this to 'Generate Custom List', and leave the start, end and separator as the default. This will keep your IN condition in the correct format when it changes during the action.

Finally, you'll want your action to replace the contents of your brackets within the IN of your filter.