Forum Discussion
Power Query Add Step
Colin970 See attached. Created the query in PQ for the Mac. It has a slightly different set-up. That's why the initial steps look a bit different. Didn't bother to re-write the M-code.
Colin970 Can you share a sample file via OneDrive or similar? Just remove anything confidential, as long as the structure/layout remains the same as your real file.
See link thers is no sensative information. Excuse my attemps to consoliate, if its too hard or you do not have time I understand. Thanks again
https://1drv.ms/u/s!AuL2hHx5FRiPib1SSjtT7GQiVgGyNg?e=Ubt3Tz
Colin970 And now please explain what you've sent and where I should begin looking. 🙂
Riny_van_Eekelen Hi yes I was not sure what to send you so I zipped all information. If you look at the spread sheet TAB 'TOP 2' that's where you will find the Query that I have been trying to update.. Hope this helps Regards Colin
Colin970 Sorry, but this is simply too much to dive into. It would take half a day to figure out what you are doing and to make it work. Looked again what I had sent earlier and think it should be rather straight-forward to implement those few steps into your data set.
All it does is take the first column and adds two index columns. One starting at zero the other starting at one. The Merge and Expand steps put the information from "row 2" on to "row 1" and so on. Then the Added column "translates" that information to either a 0 or the word "Top-2".
Perhaps it would help if you started from scratch. Now, you have three attempts to get files from a folder and a lot of, what seem to be unnecessary steps, that just clutter the whole lot. I'm working on a powerful PC but my Excel hung-up after trying to reset the connection to the source files included in the zip-file. So, I gave up.