U can use directory.getfiles to count the number os files on directory, if the number is higher than what you want use a for with move activity to move your files
I want to read fix number of rows from excel file and save in another excel sheet. I need to do this process in iterations where no. of rows are not fix... How can I write loop for it?
Suppose I have report with 2460 rows. The loop must run for 5 times and create files with rows: 1-500 501-1000 1001-1500 1501-2000 2001-2460. How can I read data from main file where Sheet range is not fix for each iteration.