Guessing there are a few steps I could remove....
Spoiler
Good exercise for sampling, dynamic rename and various cleanup tasks
Process:
- Upper thread strips out the as of date and ultimately appends it to the other data
- Lower thread
-- Skip blank records
-- Rename fields with top row
-- Extract ShareClass data with Formula and Multi-Row Formula
-- Delete the records where ShareClass was derived (Null in Fund fields)
-- Clean-up and append to date
Process:
- Upper thread strips out the as of date and ultimately appends it to the other data
- Lower thread
-- Skip blank records
-- Rename fields with top row
-- Extract ShareClass data with Formula and Multi-Row Formula
-- Delete the records where ShareClass was derived (Null in Fund fields)
-- Clean-up and append to date
Found this challenge very informative in terms of learning how to use Dynamic tools and use of IF statements in Multi Row Formula tool.
Here's my solution.
Spoiler
I made my workflow a little overcomplicated by automating most of the column ordering, but it works.
