Hi Maveryx,
A solution to last week’s challenge can be found here.
There's a saboteur among us! Martin Ding brings us this intriguing challenge today. Thanks, Martin, for this brilliant idea.
A saboteur has infiltrated our team and has been secretly sabotaging operations and eliminating our colleagues. You have been given a dataset from the security department that includes the date, time, room, and personnel logs for an office building where the saboteur is hiding, as well as details of each incident and their corresponding victims.
So far this is the information you have available:
- The saboteur has eliminated seven victims in total.
- The saboteur avoids daylight and only works during nighttime (8:00 PM to 6:00 AM).
- A macro is provided to help you to confront the suspects.
- Hint: To connect to the macro correctly, the output of your last tool should contain the following fields: Date, Time, Room, Personnel Logs, Incident, and Victims. (Each row should only have a single employee’s name; so, do not concatenate the names.)
- The saboteur has a fake name, so once you discover who the person is, you should determine their real name.
- Hint: The real name is the employee’s name spelled in reverse order (no spaces).
Your output should include both the saboteur's fake name and real name.
For your reference, we have included an additional hint within the workflow that contains the list of suspects.
Need a refresher? Review the following lessons in Academy to gear up:
Good luck!
C440.
I could only narrow it down to 3 suspects. The only other clue after that is suspect name.
Unfortunately because I am using old Alteryx version, I could not export this workflow, so I had to put out contents of the macro outside.
