Forum Discussion

Copper Contributor

May 30, 2018

Solved

error importing query

I created a query to a folder that contains 3 worksheets, all three have the same data types, my query would bring the data from the date column and the data from the column with values, the error oc...

excel

SergeiBaklan
Jun 03, 2018
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.

Ricardo Herrera

Copper Contributor

Jun 02, 2018

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.

SergeiBaklan

Diamond Contributor

Jun 03, 2018

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.

Ricardo Herrera
Copper Contributor
Jun 04, 2018
Hi Sergei,
Você estava correta, copiei o nome das colunas e as colei, atualizei e funcionou.
Muito obrigado por sua ajuda!
- Ricardo Herrera
  Copper Contributor
  Jun 04, 2018
  Hi Sergei, You were correct, copied the name of the columns and pasted them, updated and worked. Thank you very much for your help!