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.

SergeiBaklan

Diamond Contributor

May 31, 2018

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.

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!