Batch Macro different output files

[omkarshinde]

Hey, is there a way to get each parameter passed into control parameter to different file output?

currently all records of batch macro are being collated into a single file however i want different file outputs every time a parameter is passed into the control parameter!
I cant use the workflow method mentioned because i am using dynamic filter to update my filter values via macro.
Therefore I cant attach file tool to the update value tool because I have already attached filter tool to it.

[omkarshinde]

However, I have 20 such rows instead of 3 thats why I need macro to automate it instead of writing a formula query for each of them.

[omkarshinde]

Can you please share the file output configuration and settings in details as a picture? I am unable to downlaod your wokrflow

[binuacs]

@omkarshinde This approach works for any number of records and is easy to implement, batch macro does the same with some extra steps

[omkarshinde]

I have a main dataset with city and state fields which needs to be filtered for city_state combinations and then a workflow logic(same for all city_state combinations) has to be applied and then output each file with dynamic file path(having city_state in the file name). Note: Batch macro unions all outputs which i dont want.

[omkarshinde]

After i followed this approach I am unable to use the workflow logic which i need to apply individually to all the city_state combinations

First I need to separate the city_state combinations then i need to assign points as per sales for that particular city_state combination only after that I need to output files with city_state combinations different file outputs.

However, when I use the formula tool to create a new field that concatenate the two fields and output them , there is no scope(no anchor) to add the workflow logic of assigning points

[PhilipMannering]

I think if you were to mock up a simple example of a couple of cities and states and how you want to "assign points as per sales", then @binuacs  can solve it for you!

[omkarshinde]

the points assigned as to be done within that particular city_state combination group meaning 100 till 0 will be assigned for all city_state combinations individually treating them as individual entities

[PhilipMannering]

I think you still need to mock up and example to aid the explanation.

[omkarshinde]

Ranking records from 1 to 1000 for every same city_state. example: All Mumbai_India records will have 1 to 1000 ranks given among them. Ranks will restart for Canberra_Austraila again for 1- 1000 ranks(I dont want to manually filter using filter tool and rewrite the entire rank workflow logic fo9r each one of them)