Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #49: Reformatting Transactional Data

MatthewBr
Alteryx Alumni (Retired)

Love testing my abilities to Utilize Transpose and Cross-Tab

Ncardenas
Asteroide

In my solution, I swapped the Formula (Trim) for a Datacleanse, the Samples with Select Records, and integrated the Dynamic Rename tool. I realized my use of the Record ID tool and subsequent Transpose and Crosstab tools were not as efficient as they forced me to add the Dynamic Rename later on. These challenges are really helping me improve! 🤠

Spoiler
Ncajamarca_0-1629217087435.png

 

MUHAMMED_NABEEL_P
Asteroide

For beginners..

lolcott
Meteoro
Spoiler
lolcott_0-1629320847215.png

 

 

In scanning others' posts, I see I used find/replace instead of Join. Interesting to see the variety of solutions!

johnyli168
Alteryx
Alteryx

solution attached!

binay2448
Bólido

Here is one Solution for it...

zoya_asgari
Alteryx Alumni (Retired)

my solution

sebastian_klotz
Meteoro

My solution.

psampaio005
Asteroide
Spoiler
psampaio005_0-1629750281273.png

 

MatthewBr
Alteryx Alumni (Retired)

Simplicity in cross tab and transform