We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Weekly Challenge

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

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #273: Filling In The Blanks

binuacs
8 - Asteroid
Spoiler
binuacs_0-1624460830627.png

 

achillesjing
7 - Meteor

Here is my solution

DataHabanero
9 - Comet

Eazy Peazy Lemmon Squeezzay

Tyro_abc
11 - Bolide

 

Tyro_abc_0-1624479847613.png

 

 

output:

Tyro_abc_1-1624479945161.png

 

Best Regards

Arundhuti

bcronnelly
5 - Atom
Spoiler
Spoiler

bcronnelly_0-1624480420580.png

dennislee
5 - Atom
Spoiler
dennislee_0-1624480745720.png

 

Can you find a shorter solution?

lbarthelemy
6 - Meteoroid
Spoiler
Spoiler
lbarthelemy_0-1624481050115.png
dschlegelmilch
6 - Meteoroid
Spoiler
dschlegelmilch_1-1624481073556.png

 

DalasJ
5 - Atom

Good practice on Row Generator 

KieranAdair
6 - Meteoroid

Interesting... Looks like I may have a slightly different solution than others. Interesting challenge 🙂

 

Spoiler
Solved using a crosstab/transpose then multirow formula to find previous transactions.

AWC.png