Search code examples
arraysgoogle-sheetsgoogle-sheets-formulaflattengoogle-query-language

ImportXML not expanded as would overwrite data

on this report I have an IMPORTXML function in Column B which is crawling a URL for the closing date specifically. URLS on column A

It mostly works fine, but on a couple of instance it will retrieve a #REF!, and the reason is stated as "Array result was not expanded because it would overwrite data in B58." This is happening in Cell B57 currently

anyone know how I can fix this?

Thank you

Solution

  • use limit like:

    =QUERY(FLATTEN(IMPORTXML(A59, "//*[@id]")), 
 "where lower(Col1) starts with 'closing date' limit 1", )