@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.
@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.
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 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.