nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Challenge #441: Unlock the Mysteries of Alteryx Server’s API Information

AYXAcademy

Hi Maveryx,

A solution to last week’s challenge can be found here.

Alteryx Server’s application programming interface (API) offers detailed insights into the workflows and users hosted on Server. Thanks, @The_Rad_Valentina , for this brilliant idea! 😉

In this challenge, you will explore two datasets: the first presents workflow details; the second lists users associated with the Server. For this exercise, the Server has a limited number of workflows and one single user. However, the underlying principles remain the same regardless of the Server size.

Note that all personal information has been anonymized to ensure privacy. Your tasks are as follows:

Prepare and clean the data in the Workflow Details dataset.
Prepare and clean the data in the Author Details dataset.
Join the users from the Author Details dataset to the owners in the Workflow Details dataset to get your output.

Need a refresher? Review the following lessons in Academy to gear up.

Want to learn more about Alteryx Server? Review the following learning path to start:

Alteryx Server Introduction

Good luck!

Challenge_441_start file.yxzp

Challenge_441_solution_file.yxzp

Intermediate

Core

Data Cleansing

Data Parsing

Accepted answers

All comments

mmontgomery

C441

Spoiler

Renaming/deselecting fields took the most time once I figured out the approach

c441.yxzp

RolandSchubert

Spoiler

Challenge_441_solution_rsc.yxzp

Erin

Not my prettiest work, but I think I got it...

Challenge_441_submission_EM.yxzp

ed_hayter

Honestly not a fan of this challenge at all.

'Prepare and clean the data' is not a particularly strong set of challenge requirements. Consequently it becomes less time spent solving a problem and more time interpreting a sample output and trying to reverse engineer what the requirements are rather than translating requirements to Alteryx logic. I appreciate that part of our job is sometimes replicating a sample data structure. I think this probably strayed across the line from problem solving using the tool to a tedious exercise.

Spoiler

Challenge_441_start file.yxzp

MelGibson

Spoiler

Okay this took longer than expected. The key is understanding when to take the version because Version 4 is used for Record 0 for the upload date, but the create date is from no version.

MG Challenge_441_Solution.yxmd

patrick_digan

Spoiler

Challenge_441_start file.yxmd

ahsanaali

Spoiler

Challenge_441_Solution_AAA.yxmd

Hub119

Happy Monday all! My solution is attached.

Challenge_441_CH Solved.yxzp

alexnajm

Fun one!

Spoiler

Challenge_441_start file_Alex Abi-Najm.yxzp

ARussell34

Values for Record 0 are a tad different, but here is my solution!

AR_Challenge441_sol.yxmd

Caramel8

Spoiler

Wondering if there is a to not have to manually uncheck the fields and arrange them.

2024-09-09 16_34_52-Alteryx Designer x64 - Challenge_441_start file.yxmd_.png

Challenge_441_solution file.yxmd

samgiroux

I admit that I used a select took instead of a dynamic approach, but I could not find a pattern for what fields should be included and not included in the final output.

Spoiler

Challenge_441_start file.yxzp

balajilolla2

Spoiler

Solution Attached
Screenshot 2024-09-09 144102.jpg

Challenge_441_start file.yxmd

DaisukeTsuchiya

Spoiler

Challenge_441_start file_DT.yxzp

olga_strubbe

I greatly enjoyed this challenge, thank you, @The_Rad_Valentina!

challenge 441_OS.yxmd

Qiu

It is fun one with many small details requiring attention.

Spoiler

Challenge_441_start file-Qiu.yxmd

wbasuki

My solution

Spoiler

Challenge_441_start file_WB.yxmd

alacoume

here is it:

Challenge_441_start file.yxmd

BSilverblatt

Thanks for the challenge! Here's my solution:

Challenge_441_BS.yxzp

Bobbyt23

Not a big fan of this one but completed.

Weekly Challenge 441 10-09-24.yxzp

jeprime

@ed_hayter
I believe you have the wrong solution - the solution you have posted is for last week's challenge. The spoiler is for this week, but your solution is not.

AkimasaKajitani

My soltuion!

Spoiler

Challenge_441_start file_AK.yxzp

Kenda

Spoiler

Challenge_441_start file.yxmd

lwolfie

I have definitely been living this one, lately.

Challenge_441_solution_LW.yxmd

Yoshiro_Fujimori

My solution.

[versionId] and [dateCreated] in the solution data are coming from different version tags, which I do not understand.

Challenge_441_YFujimori.yxmd

aatalai

C441

aatalaiChallenge_441_solution.yxzp

CSmith16

Here's my answer:

Spoiler

Solution:
Screenshot 2024-09-11 102432.png

Challenge_441_CSmith16.yxzp

nSpire

Spoiler

Challenge_441_nSpire.yxzp

TurboToad

Went with a quick and dirty solution. Wouldn't use this in a production environment. Also know there is a published version category in that DB so you don't typically have to sort through all the versions.

Spoiler

TT_Challenge_441_solution file.yxzp

Yogesh1795

Easy one

Challenge_441_start file.yxmd

mithily

This was so fun just after I had done training in server API's very memorable challenge- Thanks SebastianChaieb

Challenge_441_start file_MCS.yxzp

mithily

The saboteur has been unmasked using reversestring

Challenge_440_start_file_MCS.yxmd

3I_ATLAS

Yes agreed. Actually, quite a bunch of challenges suffer from this same issue. Instructions are vague and unclear to the point that figuring out what the challenge is asking for and which fields to use in calculations/formulas etc, is harder then the actual building of the workflow!! If I wanted vague requirements, I can just go to my users! LOL