Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Cloud Quests

Elevate your workflow skills by solving real-world challenges using the Alteryx Analytics Cloud Platform.

Cloud Quest #26: Concattributes

ggruccio
ACE Emeritus
ACE Emeritus

Fun and required some thought!

 

Spoiler
Two separate datastreams - one that used the summarize tool to concatenate with \n as the delimiter and the other as comma-space.

Screenshot 2025-01-23 165711.png
JeffF
Alteryx
Alteryx

I think the instructions could be a little clearer about the stats column. The expected output does not include the stat if the value is empty. I figured that out after my result didn't match the provided output.

I spot checked a couple of other posted solutions and they missed that detail. As an example, for ID 3 - Absorbing Man they show:


Height - 193
Weight - 122
Intelligence -
Strength -
Speed -
Durability -
Power -
Combat -

 

Instead of this from the provided output file:
Height - 193
Weight - 122

Carolyn
12 - Quasar
12 - Quasar

Solved!

 

Spoiler
2025-01-24 11_59_33-.png
patrick_digan
17 - Castor
17 - Castor
Spoiler
image.png
AkimasaKajitani
17 - Castor
17 - Castor

My solution!

 

Spoiler
image.png
JoachimCaronTIL
8 - Asteroid

Here is my solution

 

Spoiler
Quest 26 JC.png

Erin
11 - Bolide

I chose to explore the differences between Standard and Cloud Native modes with this challenge. Here's what I found:

 

Standard:

Spoiler
- Needs a strong internet connection (this 100% could be a just me problem, but I had a hell-of-a time getting the input to work, lots of CTRL+SHIFT+R, deleting the input and reconnecting, etc. which is why I rebuilt this in Cloud Native to begin with)
- Recognized all the fields as string even though it wasn't coming from a csv (which could be a me problem again, though somewhat supported by Alteryx documentation)
- Able to properly handle newline concatenations (\n)
CloudQuest_26_Standard.jpg

Cloud Native:

Spoiler
- Input worked way smoother, no refreshing the browser multiple times required
- Recognized the data types better
- Doesn't support concatenating with newlines (\n). Even though it looks right in the configuration window, the export skips over it as if there isn't a character there at all, or treats it as a literal string "\n". I tried this multiple ways with Summarize and Crosstab. I tried regex replace afterwards to replace "\n" with a real new line, and no dice. ToChar(10) isn't supported in Cloud Native (as of today, 2025-07-26), which makes me think maybe new lines aren't supported either. I couldn't validate this in the Alteryx documentation (maybe I missed it) but since the original JSON start file was for standard mode, I suspect it is because new lines aren't an option (yet - hopefully). Again, this is just my conclusion from playing around - maybe I'm wrong? If so, please please let me know how to make new lines work in Cloud Native!
CloudQuest_26_CloudNative.jpg

 

 

Erin
11 - Bolide

My previous post (above) didn't count towards completion. Maybe I was getting too deep in the weeds. Trying this again with just the standard version....fingers crossed!

Spoiler
CloudQuest_26_Standard.jpg
mkeiffer
10 - Fireball
10 - Fireball

Another fun one! 

Spoiler
Screenshot 2025-07-27 at 6.18.23 PM.png

bradshaw
Alteryx
Alteryx
Spoiler
Screenshot 2025-08-06 at 10.29.04 pm.png