Conditional Output Based on Number of Records

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!

Workflow

Developer

Output

Accepted answers

JosephSerpis

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.

500_Records.yxmd

All comments

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

500_Records.yxmd

AMalkin

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.

500_Records.yxmd

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.

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167