Challenge #152: Finding Vehicle Counts

This week's challenge shouldn't provide anything too difficult, per se. What we need you to do is to simply find the 'count' of Blue Chevy vehicles in the Gypsum Hills region. Here's the twist: you are not allowed to use an Input Data tool, or a Summarize tool. Good luck!

Here's a small clue - do you know the name of this place:

Spoiler

It's CALGARY!

Download Vehicle Info

Download Region Info

challenge_152_start_file.yxmd

Join

Preparation

Advanced

Intermediate

Calgary

Data Preparation

Accepted answers

All comments

pasccout

No input... no summarize...

challenge_152_my_solution.yxmd

patrick_digan

Spoiler

I think a calgary join could be used if the index files were included, but without those I've used a recordID and sample tool to get the count:

challenge_152_start_file.yxmd

T_Willins

Easy. Go Flames!!!

Spoiler

challenge_152_solution.yxmd

JoeM

@patrick_digan, I just updated the links to include the index files. D'OH!

cgoodman

First time using these tools

Spoiler

I'm expecting there's a way these can be done entirely using the calgary tools ?

Challenge 152.JPG

challenge_152_solution.yxmd

pjdit

First time using Calgary data. couldn't get the calgary joins to work without an index, but still got there.. Fun!

Spoiler

challenge_152_PD_Solution.yxmd

PadmajaS

Nice Challenge!

challenge_152_PJ_Solution.yxmd

patrick_digan

Spoiler

Using the indexes, I opted for the cross count append tool:

challenge_152_start_filev2.yxmd

KevinW

Oh Canada...

one thing to watch for in this challenge - some tools are macros - for example, "Count Records" is a macro that uses the Summarize tool (and is therefore not allowed for use in this challenge).

Spoiler

challenge_152_solution.yxmd

ipeng

Spoiler

IP_challenge_152_start_file.yxmd

CharlieS

Spoiler

The Calgary Join can be configured to return the count of records that match certain criteria. So these are the only two tools needed.

Challenge_0152-CharlieS_Solution.yxmd

pjdit

This time using the Calgary tools available..

Spoiler

challenge_152_PD_Solution2.yxmd

KevinW

Ahhh.... much easier now that the index files are there.

Spoiler

I could have restricted the data to just count for the Blue Chevy's in the Calgary Cross Count Append, but put that in the filter instead so that any color or model of car could be checked on.

challenge_152_solution_with_Calgary_indexes.yxmd

ddiesel

First time using Calgary tools. I like the features!

Spoiler

challenge_152_end_file_ddiesel.yxmd

ponraj

Here is my solution. I have never heard about this place. However, google image search helped me to find this place

Spoiler

challenge_152_solution.yxmd

JosephSerpis

Challenge Completed

challenge_152_Joe_Serpis.yxzp

rfergus

Spoiler

Went the Calgary Input and join route too. Originally had a filter as well, but saw in the other solutions you could include query criteria in the calgary input. First time using these tools.

challenge_152_RF.yxmd

estherb47

GREAT city! FUN tools. I've done very little with these so far, and clearly need to play some more

Took 2 approaches, one with a regular join, and one with a calgary cross count. Calgary join worked, but didn't get all of the fields I wanted in the output

Spoiler

challenge_152_EHB_solution.yxzp

sachin02

My solution without use of input data and summarize tool:

challenge_152_start_file_sachin.yxmd

Sebenius

Intrestnig playing around with a new tool.

Managed to find the correct tools to match the output 100%.

No input tool used that includes the calgary input as well.

Spoiler

Challange 152

challenge_152_Done.yxmd

Aidan_K

Thanks for the intro to Calgary tools @JoeM !

Having started looking through everyone else's solutions I see there is cool ways to use only Calgary tools...

A lot more playing around with these tools for me today so!

Aidan

******

Update - I think I may have missed the brief in my first attempt

(it was waaay too early !)

Second attempt with no input AND no summarize tools!

thanks

challenge_152_AidanKing.yxmd

challenge_152_AidanKing2.yxmd

erambeau

Hi,

Here is my solution.

Interesting to discover these tools.

Emmanuel

challenge_152_erambeau_solution.yxmd

kparvanova

challenge_152_start_file.yxmd

sachin02

My solution without use of input data and summarize tool:

challenge_152_start_file_sachin.yxmd

matyohan

Canadian Solution!

Spoiler

Wouter

My solution:

Spoiler

challenge_152_solution_WK.yxmd

kat

Spoiler

Challenge #152.yxzp

LucaCesario

Spoiler

Even though I opted for the simpler solution at the beginning, then I found out that the Calgary Cross Count Append is the best tools for this challenge

challenge_152_start_file.yxmd

Niklas

Spoiler

Solution_152_NE.yxmd

Ganeshkumar_4

challenge_152_start_file GANESHKUMAR_4.yxmd

unknown

CE challenge_152_start_file.yxmd

RolandSchubert

My solution. I used Calgary tools for the first time, very interesting.

challenge_152_solution_rsc.yxmd

danilang

New Challenge...New tools...It's a good day.

It's interesting that the Calgary Cross Count Append capitalizes the Model and Color info, whereas it's lower case in the .cydb. Any ideas why or how to change this behaviour @JoeM? No obvious configuration options for letter case.