Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.
- Posts: 5
- Joined: Fri Sep 09, 2016 11:59 am
How I can split rowset with 500K rows to parts, let say 65K each?
and then use it in For each loop to write files.
- Posts: 592
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
If the file is already in a "rowset", then you don't have to "split it up"... just loop through the RowSet (Use a For-Each loop)...
Then, if you need to "split" at each 65k limit, just put a counter inside your loop then change destination files as you write out each record to a target file.
Lead Solutions Consultant
Return to “Community Forum”