Conditional Output Based on Number of Records

[AMalkin]

Hello,

I searched around, but haven't found quite what I'm looking for. 

I have a script where I need to create an Excel file but limit it to 500 records. If there are more than 500 records in the output data, then a second (or third) output file needs to be created.

Is this possible? 

Thank you! 

[Bdonahue]

Batch Macro would be your best bet if you have an unknown number of records coming in.  You set up the macro to create the file with batch being the control parameter.  In the workflow you'd just group them into groups of 500.

[AMalkin]

Thank you so much! Can you explain a bit more? I'm a pretty new user, and not familiar with macros. 

Thank you!

[JosephSerpis · Accepted solution]

Hi @AMalkin if you are creating an excel file in the output tool you can specify the Max records per file. Once it reaches the limit it will create another file. If that doesn't work I mocked up a workflow that should create a new file once it reaches 500 records.

[AMalkin]

Hi @JS420 That's perfect, thank you!! 

I have a follow-up question: the records are line items with a price attached and each output needs to have a total included in the file (total for that output, not all). Is it possible to include the total per output if the output is variable on the number of records? 

[JosephSerpis]

Hi @AMalkin the attached is a slightly amended workflow where it produces a total for each file.

[AMalkin]

@JS420 is there anything Alteryx can't do?? 

Thanks so much!!

[JosephSerpis]

There is not much Alteryx can't do @AMalkin where there is a will there is usually a way.