Advanced Certification Exam Prep Guide - Practice Question 6

[mehulrp]

https://community.alteryx.com/t5/Exam-Prep/Advanced-Certification-Exam-Prep-Guide/ta-p/409406

Despite numerous attempts, I am unable to get answer (C) 39.

Was anyone successful in their attempt? Would be curious to review your workflow to understand my error. Currently am getting (A) 34. My workflow attached in case anyone is interested.

[edgarl · Accepted solution]

Remove your unique tool after the RecordID Tool.

Although there are duplicates on the non RecordID columns, you are not required to filter them out.

These are 2 reported sightings at the same time and location. (Could be by different people)

They key word is reported sightings and not unique sightings.

Use the unique tool at the end instead of your workflow just on Record ID only as you are counting for reported sightings.

Each unique Record ID = 1 reported sighting

Spoiler

[jacob_kahn]

@mehulrp 

Can you please tell me where you got these workflows! I've been preparing for the exam and thought I covered every resource there is on the community; or at least knew what was available!

thank you thank you thank you

Jacob 🙂 

[mehulrp]

Create the workflow from scratch as a response to the practice question.

[mehulrp]

Thanks. Question finally made sense after seeing your response.

[RWvanLeeuwen]

Here's your workflow but with 39 IDs as result. The difference is with Record 391 which overlaps in both location and time with another record (matches with 366 and 392) which results in a duplicate row

Spoiler

I removed the unique tool in your portion of the workflow, and I added a second stream lower on the canvas so you can see my approach side by side.