I queried from my sheet but its case sensitive. How can I remove it? My query as below:
=ArrayFormula(IFNA(IF(QUERY('pending SKUs'!E2:AQ,"select F, G, H, L, M, N, O, I where E='tree' AND P <> 2 AND P <> 3 AND X='Pass' AND AQ <> 'Rejected'")="",0,
QUERY('pending SKUs'!E2:AQ,"select F, G, H, L, M, N, O, I where E='tree' AND P <> 2 AND P <> 3 AND X='Pass' AND AQ <> 'Rejected'")),""))
I want to include "tree tree", "TREE tree", "Tree tree" and any other possible case used between all the alphabets.
I also prepared the gsheet: https://docs.google.com/spreadsheets/d/1DwgOVhsChyCw4NQtUyOx3q_4BoXLpBkN0U0RllNHFec/edit#gid=123192750
>Solution :
You only need to include lower() function to your where condition part. Try-
=ArrayFormula(IFNA(IF(QUERY('pending SKUs'!E2:AQ,"select F, G, H, L, M, N, O, I where lower(E)='tree tree' AND P <> 2 AND P <> 3 AND X='Pass' AND AQ <> 'Rejected'")="",0,
QUERY('pending SKUs'!E2:AQ,"select F, G, H, L, M, N, O, I where lower(E)='tree tree' AND P <> 2 AND P <> 3 AND X='Pass' AND AQ <> 'Rejected'")),""))