The link to last week’s challenge (challenge #27) is HERE
Use Case: A company has to process financial data for their visualization tool. Today this is a manual process in Excel.
Objective: Build a process in Alteryx that automates the formatting of the daily data feed.
Note: This data comes in daily and is always in the exact same format.
Challenge 28 solved
Great challenge! My method is a little bit more complicated. I've learned a lot from the solution.
Here is my solution
Solution attached! Good practice for a pretty practical use case in my work!
Solution attached.
My solution :
I had to look at the mult-row formula to figure this one out. It threw me off on how that was done. Great functionality to be able to write an expression that refers to itself. I was surprised at its capacity to do so.
never-displayed
