Outputting to Excel - too many records

Question

I am outputting my data to Excel.  My output has 1 tab for each vendor from my source file but some vendors have too many records.

How can I split those vendors into multiple tabs (Vendor A - 1, Vendor A - 2, Vendor B, Vendor C - 1, Vendor C - 2, Vendor C - 3, Vendor D for example)?

Thanks!

IraWatt · Answer

Hey @TeamTJ,

You could use the sample tool grouped on your vendor ID. The top tool takes the first 100,000 rows for each vendor, the bottom sample takes everything after the first 100,000. Then you just add a "_1" to the file name for fist 100,000 and "_2" for the rest:

HTH,

Ira

Split Data.yxmd