This workflow divides input table based on data from another table where it is specified how many rows new data sets/files should have. Logic is contined in Column Expression or Rule Engine node.
This is a companion discussion topic for the original entry at https://kni.me/w/mYuP03b_AuN_BQGH