Home > Back-end >  Is there a Google sheets function that allow you to do multiple queries for different data sets with
Is there a Google sheets function that allow you to do multiple queries for different data sets with

Time:10-08

So I have a couple of Google Sheets tabs that contain similar data and want to merge into a master sheet, but have two different conditions for each query. I have tried:

={query({INVENTORY!$A:$Z},"SELECT Col1, Col2, Col3, Col4, Col5, Col15, Col17, Col18, Col7, Col11, Col12, Col13, Col14 WHERE Col15 IS NOT NULL and Col15 < "&F1&" and Col19 <> 'Printed' AND Col20 = 'Restock' ORDER BY Col15 ASC LIMIT 200",1),query({PREINVENTORY!$A:$O},"SELECT Col1, Col2, Col3, Col4, Col6, Col7, Col8, Col9, Col10, Col11, Col12, Col13, Col14 WHERE Col15 = 'X'")}

and

=QUERY(IMPORTRANGE("url", "INVENTORY!$A:$Z"),"SELECT Col1, Col2, Col3, Col4, Col5, Col15, Col17, Col18, Col7, Col11, Col12, Col13, Col14 WHERE Col15 IS NOT NULL and Col15 < "&F1&" and Col19 <> 'Printed' AND Col20 = 'Restock' ORDER BY Col15 ASC LIMIT 200",1)QUERY(IMPORTRANGE("url", "PREINVENTORY!$A3:$P2000"),"SELECT Col1, Col2, Col3, Col4, Col5, Col7, Col8, Col9, Col10, Col11, Col12, Col13, Col14 WHERE Col16 = 'X'")

CodePudding user response:

try:

={QUERY(IMPORTRANGE("url", "INVENTORY!$A:$Z"), 
 "SELECT Col1,Col2,Col3,Col4,Col5,Col15,Col17,Col18,Col7,Col11,Col12,Col13,Col14 
  WHERE Col15 IS NOT NULL 
    AND Col15 < "&F1&" 
    AND Col19 <> 'Printed' 
    AND Col20 = 'Restock' 
  ORDER BY Col15 ASC 
  LIMIT 200", 1);
 QUERY(IMPORTRANGE("url", "PREINVENTORY!$A3:$P2000"),
 "SELECT Col1,Col2,Col3,Col4,Col5,Col7,Col8,Col9,Col10,Col11,Col12,Col13,Col14 
  WHERE Col16 = 'X'")}
  • Related