I am trying to input data from an excel file i receive periodically (it has a variable number of rows) into the first blank row of a master file which is meant to store all the data from all the periodical reports received.
For this, I have so far created a sequence with a read range for the received report (the range I selected goes until row 10000, so there is no risk of leaving out information) yielding a data table (DT1). Then i make another read range on the master file (yields DT2), and a foreach row of DT2, If (row(0).toString=""), a write range (DT1) in the master file, on cell “A”+DT2.Rows.IndexOf(row).ToString (i believe this gives me the first blank row).
So far, it keeps writing only the first row if the input in the master file, repeatedly until the end of the range read. I need it to input the full DT1 in the first blank row of DT2 and stop there.
I hope I was clear, this is my first post and besides my introduction days to UiPath.
Thank you for your help! Please let me know if I can provide any further info.