Batch Macro different output files

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.

Workflow

Output

Macros

Batch Macro

Interface Tools

Accepted answers

All comments

binu_acs

@omkarshinde You need to use the output tool inside the batch macro and save the file based on the parameter value

philipmannering

I would create the FilePath outside the macro (presumably the filename is based on the parameter values used in the macro), pass it in and have the Output Data Tool update based on field values.

omkarshinde

I already tried doing this however only one iteration is run containing all the records!

omkarshinde

exactly can u tell me how do i use file output inside the macro because as i mentioned my change value via control parameter is already being used for dynamic filter so I dont know how do I add file tool now to it via control parameter

binu_acs

@omkarshinde If you want to reflect the control parameter you are using in the filter tool to the output tool, connect the same control parameter to the output tool and update the action tool settings. An example give below

omkarshinde

I tried to do what you suggested but I have two update values(consider city and state) in my batch macro via the same control parameter and when i connect the third update value to the file tool via the same control parameter i want the file names as city_state every time a new city and state is passed. So i tried to bring city and state together via formula tool however I am facing difficulty in putting together all of this.

Can you take example of city and state control parameters and explain further please?.

binu_acs

@omkarshinde would you be able to provide some sample data and based on your requirement also the expected output?

omkarshinde

I want to create multiple file outputs for every row of city and state. example:there are 3 unique combinations of city and state above so my main dataset should be filtered for these 3 combinations and 3 files should be created dynamically named city_state.

The main dataset to be filtered woould look something like this below.

Note: I have already tried creating batch macros for same but it just collates all of my output records into single file instead of multiple files as required.

binu_acs

@omkarshinde For your use case I don't think you need batch macro, in a formula tool and create a file path with the city and state name (concatenated) then in the output tool update the file path variable. Attaching a sample workflow for your reference

State_City_160823.yxmd

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

binu_acs

@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 @binu_acs 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)

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

Aguisande 317