My process needs to read ranges from multiple excel files. The number of excel files I need to read and combine also changes daily.
My issue is that the read range activity overwrites the datatable variable in it’s output.
So only the last read file is in the data table.
Is there a way that I can read multiple excel files without overwriting the datatable variable?