Combining multiple IMPORTRANGE WITH QUERY

Question

I'm trying to import data from multiple spreedsheet to one using query,

=QUERY({IMPORTRANGE("1wMGl6qkQuz5ux42u4w8YAIEGiB3SN2b4EcgVJI-RTx4","DELIVERY DETAIL!$A$3:$I");
IMPORTRANGE("1A2dgmXRWbCzc9_jH38WruOMALsXrq8RFx7BcDW9Z8EI","DELIVERY DETAIL!$A$3:$I") }, 
"SELECT Col1,Col8,Col9 ",0)

the problem for me i get the data from one spreedsheet and receive nothing from the 2nd one,(i tried both of the importrange seperately without the query and it's working good), and it's importing the data from the source but when both of the importrange work it bring just data from 1st spreedsheet BTW the name of the tabs are the same as i made duplicate the same spreedsheet

player0 · Accepted Answer · 2022-04-05 23:03:55Z

1

you did not filter out empty rows. try:

=QUERY({
 IMPORTRANGE("1wMGl6qkQuz5ux42u4w8YAIEGiB3SN2b4EcgVJI-RTx4","DELIVERY DETAIL!$A$3:$I"); 
 IMPORTRANGE("1A2dgmXRWbCzc9_jH38WruOMALsXrq8RFx7BcDW9Z8EI","DELIVERY DETAIL!$A$3:$I")}, 
 "select Col1,Col8,Col9 
  where Col1 is not null", 0)

answered Apr 5, 2022 at 23:03

player0

131k14 gold badges91 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Combining multiple IMPORTRANGE WITH QUERY

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related