create separate data streams or separate into files based on unique numbers

[yuanlu]

Please see attached example files which has a PD column with about 43 unique ID for each years. Is there anyway I can separate this file into 43 data streams or 43 single data sets? then I can perform a series of calculations (same for each separated data set) on separated data sets.

For example one of separated data set would look like this:

Year	PD	Amount
01-31-2018	13	144720.4
11-30-2017	13	284440.3
12-31-2017	13	235645.1

[JagdeeshN · Accepted solution]

Hi @yuanlu ,

Please find attached an Alteryx package that executes the logic you have described. This workflow contains the following two solutions:-

1. Use of a simple Batch Macro. The logic for calculations for the individual year's/pd's goes within this batch macro. 

2. If you just looking to split the input stream into individual output files based on the year and then subsequently use each of these files to do your calculations, it can be achieved using configuration as shown below on the output tool.

Do let me know if this helps.

Best,

Jagdeesh

[yuanlu]

Hi JagdeeshN, thanks for your answer, but I got an error (attached), not sure what it is?

[yuanlu]

I changed the Macro and workflow, but I had an error "Error: batchmacro-1 (16): The Control Parameter "Control Parameter (16)" must be mapped to a field."

[Qiu · Accepted solution]

@yuanlu 
Go to configuration window of the macro by clicking the macro, then go to the Question Tab.
This is where we map the field.