Looking for a way to input groups of data into a batch macro and process each group

jaiwalke

Hi everyone,

I'm currently working through a large data set (300k rows) and and I've managed to group unique identifiers towards a record ID for example:

ID	Key values	data 1	data 2
1	abc	4352	Alaska
1	abc	500	Ohio
2	xyz	6453	New Jersey
2	xyz	48489	New Jersey
3	jkl	845	Colorado
3	jkl	2354	California

I'm currently trying to process each of these to a batch macro to output each set of ID which are the same as separate records for example:

ID	Key values	data 1	data 2
1	abc	4352	Alaska
1	abc	500	Ohio

My current theoretical solution would be to iterate through each record, but I'm not sure where I'd begin. Any help would be appreciated, thank you!

SPetrie

Thanks for the clarification!

You can use a batch macro to do this, but I think it may be a bit overkill.

Since you already have an ID that indicates which items are to be split up into different files, you can use that field to generate a name column and have an output tool do the splitting for you.

A formula such as ".\MyFile-"+ToString([ID])+".xlsx|||sheet1" for example, would create an excel file called MyFile-## for each ID it found and would only have those ID items in them.

I attached an example workflow showing this method.

example.yxmd