AnsweredAssumed Answered

Drill - how to query Array of Strings?

Question asked by BOBcoupon on Jul 12, 2017
Latest reply on Jul 12, 2017 by arjunkr

Hi,

I cannot seem to query the Attributes. I would like a query that selects all businesses that accept credit card which is Attributes.BusinessAcceptsCreditCards = True

 

Drill is giving me issues with dot notation and index notation ... how do I get all businesses that accept credit cards?

 

*I tried Flatten() did not work

yelp_academic_dataset_business.json

{     "business_id":"encrypted business id",     "name":"business name",     "neighborhood":"hood name",     "address":"full address",     "city":"city",     "state":"state -- if applicable --",     "postal code":"postal code",     "latitude":latitude,     "longitude":longitude,     "stars":star rating, rounded to half-stars,     "review_count":number of reviews,     "is_open":0/1 (closed/open),     "attributes":["an array of strings: each array element is an attribute"],     "categories":["an array of strings of business categories"],     "hours":["an array of strings of business hours"],     "type": "business" }

Outcomes