Hi Lea,

I can't read your files as I don't speak Hebrew, but that error means that the column labels in the second file don't match those that the query was built on. 

Mynda

hi,
As for the error, how can the column labels be incorrect?
I downloaded from the system to Excel 2 files with a fixed structure - only the data is different
And even if we look at the tables now - these are the same columns, the same titles,
Only the data inside is different
So why is he still displaying this error message?
Will it help if I translate the file into English?

thank you!!!

lea

Hi Lea,

In that case it'll be other names throughout the query causing the problem. e.g. the worksheet names are different in each of those files. Did you change the reference to the worksheet name in the query editor? e.g. the Transform Sample File query contains references to the sheet name as does the Transform File function. The final query under 'other queries' also includes a reference to the original file name.

When you get files from a folder the sample file information is hard coded in the queries generated upon combining. If you remove the file used as the sample file your query will fail because it's looking for that sample file name and the sheet name for that file. You either have to rename the replacement sample file so it matches what the query is looking for, or edit the query and replace all references to the original file with the new file name and sheet name.

It's probably easier to name the replacement file with the same file name and sheet tab names. I hope that points you in the right direction.

Mynda

Thanks for the detailed answer!
I did check and the name of the issue in both was not the same-
There was a small change I had not noticed before.
Thanks!!!!