community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #49: Reformatting Transactional Data

Alteryx Certified Partner

My solution :)

Alteryx Partner

My solution:

Spoiler
challenge 49.jpg
Asteroid
Spoiler
Never really used the Select Records tool, I was surprise at how versatile it can be, especially with those pesky Finance Excel workbooks!
Alteryx Partner
 
Alteryx Certified Partner

Cool one.

Asteroid

Tons of answers, but tried to leave enough in the annotation that someone could figure it out without downloading :)

Spoiler
2018-06-13_15-39-46.jpg
Alteryx Partner

I tried to overcomplicate this with 4 different splits, 3 different formulas to create columns in each then joining them together. Transpose and Cross tab saved me from getting lots down the rabbit hole. I need to spend more time using these tools.

Meteoroid

I definitely make these are much harder than they are in my head. I can say that I knew i had to do a transpose & cross tab but couldn't figure out how to properly execute it. I took a look at  a few other solutions to see if I was on the right track and I was! I did  figure out early on with Google to use Select Records tool prior to looking at other solutions...so I'll pat myself on the back for that lol. 

My solution is below

Spoiler

 

Solution attached

Alteryx Partner

Hi,

 

I could not understand why the formula on the upper row was used. (trimming value). It does not work without it but theoutput looks the same before and after the formula

 

 

Thanks

 

 

MG