Need a software that will let me input file1 with say 1 million records, and file2 with 20k records as an example. I will then combine the two files, but it will be in a specified ratio and also specified amount. if I enter a ratio of 1:10 for example, and choose 100k records of file 1, then for every record in file 1, there will be 10 records of file 2 once new file is created. Final file will have 100k records from file 1, and 1 million records from file 2 as this will have a 1:10 ratio. If there is insufficient data for so many records then the records can be repeated.
Also, I want it to keep track of where it left off in file 1. If last time I ran it I collected 100k records, then next time it should go to next 100k records on the list if I choose to run it again.
Final file will have records in randomized order and combined in whatever ratio I chose.