Hello,
Is there any way to dynamically create batch groups?
The record number of input file is different on each project. In order to run the file within the batch macro, I would like to split records into small groups. I would like to assign batch group by every 10,000 record.
Desired output contains "batch" column to specify the batch number.
I used a formula tool to do so, but this is not dynamic at all.
Is there any way to dynamically assign batch group? I've attached a sample workflow.
Sincerely,
knozawa
Solved! Go to Solution.
Would you be able to use the Tile tool with Equal Records option to create batches?
Hi@DavidP ,
Thank you for your reply.
I think equal records option is good when the maximum number of records is the same for all input. However, I might have 100,000,000 records or sometimes 500,000 records. If I would like to separate batches by 10,000 batch records, I'm not sure if we can do that using the tile tool.
Sincerely,
knozawa
Hi
I noticed you have a RecordID. Below is the formula I would use to create the BatchID for batches of 10,000 records
FLOOR(ToNumber([RecordID])/10000)
Kind Regards
Craig