Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Querying Distinct Values in a Calgary DB

MarqueeCrew
20 - Arcturus
20 - Arcturus

@Treyson,

 

Per your message:

 

Mark! I hope the season is treating you well. I imagine that it is terribly cold in Michigan.

 

Someone approached me about querying distinct values from a field in a Calgary DB. I have seen you post a bunch of stuff about Calgary so I was wondering if you know how to go about that. 

 

Well, the solution is forthcoming.  Not only was I able to drive home and answer your question first, I was able to post the question too!

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus

@Treyson

 

Please do checkout the Calgary Crosscount tool https://help.alteryx.com/11.7/index.htm#CalgaryCrossCount.htm

 

It will do you wonders!

 

Cheers,

Mark

 

P.S.  85 degrees and sunny is akin to "Good Luck With That!".

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Treyson
13 - Pulsar
13 - Pulsar

Ha! Yes this worked exactly as I needed to. One thing that I will note is that the "Cross Count" tool will not work with YXDB files, which is what that person was using. Should have checked that first. 

Treyson Marks
Senior Analytics Engineer
Labels