Mynda,
Just started last night and already half way through Power Query... so powerful.
Great course so far!
As an observation, I would imagine that the combination of 4.17 and 2.05 would work if the best monthly or whatever timing update report you could get from someone resembled one of the last two in 4.17?
[Side Note] While watching 4.17, it reminded me of a program I used a long long time ago called Monarch which stripped data out of reports consistently after setting up (highlighting) the first one and saving that as a template/filter to apply to future runs. Think it might still be around, but likely owned by different company and a whole lot more expensive than it was.
Thank you.
Hi Cliff,
Great to hear you're seeing the benefits of Power Query already.
When making transformations on files from a folder, that you want applied prior to the merge of the files, you just need to make sure you make them on the Sample Binary. This will then apply the same transformations to the other files in the folder.
Mynda
