The link to last week’s challenge (challenge #27) is HERE
Sorry for the delay this week. Yesterday (Monday) was Memorial Day, a US holiday to honor those that died in active military service. This will be the last challenge until June 13th due to the Alteryx Inspire Conference being held next week in San Diego California. For those of you attending the conference there will be a group review of this challenge at the community hub where you can share your solution. It should be a great way to see firsthand how many possible solutions a single exercise can have. We may even come up with a prize for the most elegant solution presented by a customer.
The challenge requires you to prepare and format a data feed coming from a financial service API.
Use Case: A company has to process Morningstar Data detailing American Funds Fixed Income Funds for their visualization tool. Today this is a manual process in Excel.
Objective: Please 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.
I look forward to meeting many of you at Inspire 2016!
IF StartsWith([F1],'Ranks') THEN
Replace(F1,'Ranks as of ','')
IF IsNull(F2) AND NOT IsNull(F1) AND NOT StartsWith(F1,'Ranks') THEN
I feel like I cheated a bit on this challenge because it was one of our training exercises at Data School. So I gave myself the added challenge of finding a different solution to the one we came up with in class!