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

Question

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:

YearPDAmount01-31-201813144720.411-30-201713284440.312-31-201713235645.1

Alteryx testing.xlsx

JagdeeshN · Accepted Answer

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

Qiu · Accepted Answer

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