Querying Distinct Values in a Calgary DB

[MarqueeCrew]

@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

[MarqueeCrew · Accepted solution]

@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!".

[Treyson]

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.