Forum Discussion
error importing query
Hi Ricardo,
That usually happens if column names in files are not exactly the same. Like in this sample
I have "Date 2" with one space in between for the first file and with two spaces in between for the second file.
To be sure you may copy column names from first file and paste them to column names for the file in question.
Hi Ricardo,
It's hard to say what's wrong without seeing concrete files. Most probably something is wrong with the second file, not in settings. To be sure you may rename copy of first file and substitute it instead of second one. If works, you shall check the second file more carefully.
Hello Sergei,
Thanks for your return, I have refactored the spreadsheet and rename it, but it did not work, I made some prints of the query, notice that the query returns as null and where it should recognize how number it does not recognize, as I said, the spreadsheet is configured correctly.
Hi Ricardo,
That usually happens if column names in files are not exactly the same. Like in this sample
I have "Date 2" with one space in between for the first file and with two spaces in between for the second file.
To be sure you may copy column names from first file and paste them to column names for the file in question.
Hi Sergei,
Você estava correta, copiei o nome das colunas e as colei, atualizei e funcionou.
Muito obrigado por sua ajuda!Hi Sergei, You were correct, copied the name of the columns and pasted them, updated and worked. Thank you very much for your help!