Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How can I specify "country" with Calgary Experian Household database?

Rujin05
7 - Meteor

How can I specify "country" with Calgary Experian Household database? Want to query # of Households in the United States only, but didn't find "Country" field I can use in query conditions. Only available are "state abbreviation", "city name", etc. It's returning me # of HH's over the world.

 

Rujin05_0-1598441705448.png

 

2 REPLIES 2
echuong1
Alteryx Alumni (Retired)

The datasets are licensed per country. I'm assuming you only purchased US data, so you shouldn't need to filter for the country as well. 

 

These are all of the separate datapacks that you can install.

 

echuong1_0-1598447835438.png

 

Rujin05
7 - Meteor

@echuong1 Thank you Echuong!! Yes I just noticed yesterday that it only contains US data (51 states).

 

Labels
Top Solution Authors