We are downloading a report from SAP where the data set is so large it has to be broken up into 3-4 reports. We are fetching the report in a loop where we put the data into a temp data table, then merge it into the main data table.
What we are finding is that on the first merge a blank row is added to the main data table at the end of the data set. Subsequent merges do not add more blank rows but push the blank row to the bottom. Our assumption is that the subsequent merges are happening at the correct position as there are no blanks rows in the middle.
We are curious if this is by design or if this is a bug? We are having difficulty looping this data table since the last row contains no data and we are having to find blank rows, delete them etc. before working with the data.
