Each of these 3 query statements work fine separately. When I combine Query 1 plus Query 2, it works as it should and return values. When combined with Query 3 - I get an error.
When query 3 is run separately "" is returned. So I know there is no data to return.
Error In ARRAY_LITERAL, an Array Literal was missing values for one or more rows.
={iferror(QUERY(Tickets!C:BK, "Select C,D,F,AA,AC where AE IS NULL AND AB = DATE '"&TEXT(TODAY()-1,"yyyy-mm-dd")&"'ORDER BY L ASC",0),"");iferror(QUERY(Tickets!C:BK, "Select C,D,F,AH,AJ where AL IS NULL AND AI= DATE '"&TEXT(TODAY()-1,"yyyy-mm-dd")&"'ORDER BY L ASC",0),"");iferror(QUERY(Tickets!C:BK, "Select C,D,F,AO,AQ WHERE AS IS NULL AND AP= DATE '"&TEXT(TODAY()-1,"yyyy-mm-dd")&"'ORDER BY L ASC",0),"")}
