ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
GELÖST

Split the output file in multiple files

msantoso
Asteroid

Hi everyone, 

I need to split the output file into several ones with less than a thousand lines in it.

I've read many discussions around this topic : use of the TILE tool, the CEIL function,

and even tried to build a sample file with the first 1000 records. 

 

all these solutions produce output files with no headers. 

 

Did I forget to specify something? or is it the normal way these solutions work? 

 

thank you 

-ms

13 ANTWORTEN 13
msantoso
Asteroid

hi 

thank you for these explanations. 

they will be very helpful for my next output filenames!

thank again!

myriam

msantoso
Asteroid

Hi Joe, 

Yes, I had LadArthur's solution and I also managed to split the output with the Select Records tool. 

 

what I learned is that there are many ways to split a file. I like to have choices !! 🙂

 

thank you

Myriam

JoeS
Alteryx Alumni (Retired)

Great stuff, I am glad you were able to get what you needed.

 

And yep, choices is always a great thing to have!

msantoso
Asteroid

thank you Joe! 

Beschriftungen
Top-Lösungs-Autoren