I’ve searched the forum for information, but I haven’t been able to .
I am talking about bulk upload of excel files with multiple worksheet .
The worksheet have identical structure .
I have created a workflow for this which works and gives results.
Unfortunately I found that if the worksheet is empty it will upload the previous records into the result. It repeats this until it encounters rows that have a non-zero value and loads those .
In the result there are duplicates loaded , and it is necessary to remove the duplicates, I stop trusting the result. There may be several hundred of these files.
The requirement is if the worksheet is empty it should not upload it, I did not assume that if it does not contain any information it will take over the ones from the previous one which is.
I want to upload all files into one table and check for real duplicates.
UR_YB_ACCforum_20220429.xlsx (14.1 KB)
UR_YB_ACCforum_20220430.xlsx (14.0 KB)