We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

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

UFO sighting: Trade Area

7 - Meteor

Hi All,


I am practicing for Alteryx advanced certification. I am referring the preparation guide. Where I am not able to understand the solution of practical question.


Prepration Guide: https://s3-us-west-1.amazonaws.com/ayx.policies/Advanced+Certification+Exam+Prep+Guide.pdf

Question: You are investigating recent UFO activity in Colorado. Given the
provided dataset on UFO sightings in Colorado, determine the number
of reported sightings that happened within 5 miles and 10 minutes of
another sighting. (Hint: Count each sighting individually. If two
sightings are within the required distance and time of one another, both
sightings count towards the total). 


Please help me to understand the solution.



17 - Castor
17 - Castor

Is the UFO problem still an active question in the Advanced exam?


If not, were you looking for the solution workflow?

7 - Meteor

I am not sure if the question is still active in Advanced Exam. I was checking the preparation guide. The question and solution is already there but i am not able to build the same workflow mentioned in the solution.

7 - Meteor

Here is the workflow, I build to solve the question. I followed the steps mentioned in the solution. Please check where I did the mistake.

17 - Castor
17 - Castor

I've attached my approach below. The data and question changed since I did the exam, so I'm not sure what the correct answer is.





Hi @Virender ,


I reviewed your workflow and you were close.  There were two small issues.


1)  You need to make sure you aren't matching each sighting to itself.  This can be done in one of your Filter tools after Append Fields with the expession [RecordID]!=[Source_RecordID].


2)  The last tool is a Unique tool to make sure you aren't counting the same sighting more than once on your list.


For future reference, questions on prep materials are not actively included on the exams.  If you think an exam question has been posted on Community, please notify a Community admin or the Certification team at certification@alteryx.com


Let me know if you have any further questions and good luck on the Advanced exam!


All the best,


Alteryx Certification Team

7 - Meteor

Hi @EricR ,


Thanks for the reviewing the workflow. I corrected the issues highlighted by you.

I am getting the correct answer now.


If I found any certifications exam questions on community, I'll notify the certification team.


Thanks for the solution. I am attaching the correct solution here.

7 - Meteor

Hi @DavidP ,


Thanks for sharing the solution, I did noticed that time and area got swapped in your solution. I just corrected that and added unique in last to remove the duplicate records.


Thank you for the solution,Now I am able to solve the question in two different ways.



8 - Asteroid


Here's another answer which seems a bit efficient 





e.g. Spatial process tool - "Don't output empty objects" ...this is ticked..one less tool to use in your answer.



ACE Emeritus
ACE Emeritus

I wanted to share one note that got me on this example which is so easy to make. I kept getting different number of records at the end (less actually) and I so I compared the one I built to @Virender 's example below and only one tiny thing ...


IN my date_time conversion of each date time I had custom and this "yyyy-mm-ddThh:mm:ss" versus this "yyyy-MM-ddTHH:mm:ss"


Once I corrected that it worked! 😉 

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks