How can I use a query in Quickwork to filter users by age and city from a Google Sheet?

Shilpa Rao

• December 12, 2024 11:13
• Edited

 I need to filter users from a Google Sheet where the age is greater than 30 and the city is either New York or Los Angeles. I'm looking for the appropriate query string and how it works.

0

• 

  Rajnish Kucheria

  • December 14, 2024 17:23

  To filter users by age and city, you can use the following query in Quickwork's Google Sheets action:

  Query String: Select * where C > '30' AND ( D = 'New York' OR D = 'Los Angeles' )

   

  • * denotes all columns in the spreadsheet.
  • C corresponds to the column header for Age.
  • D corresponds to the column header for City.

  This query retrieves all records where the age is greater than 30 and the city is either New York or Los Angeles. Use this query in the Query String field of the "Search cell using query" action in Google Sheets.

   For further guidance, refer to this article: How to use queries in Google Sheets with Quickwork.

  0

Please sign in to leave a comment.