Hi,
I have an issue when trying to append two tables in Power Query.
I have two tables that are both linked to SharePoint folders and both queries pull in all files from each sub directory.
On a daily basis we have ongoing work files (table1) and completed work (table2).
Before I import any new queries each day, I get a unique list of job ID’s by appending both of these tables then remove duplicate ID’s,
The problem I have is that there isn’t always ongoing work files in the folder so if the folder is empty then it breaks the query due to the table being empty and I receive the below error.
An error occurred in the ‘Sample File (3)’ query. Expression.Error: There weren't enough elements in the enumeration to complete the operation.
This then prevents me appending table 1 to table 2.
Is there any way I can prevent this from happening so if table 1 is empty then it doesn’t do the append step? I have read that a try...otherwise statement might help?
The problem is that as the table returns the above error I can’t even see it when I bring up the append window as Power Query doesn’t list the table (table1).
I’m not trying to create a new table, just trying to append table1 data into table2.
Any suggestions please?
