Estimating
Estimating could include material take-offs for simple quantities or complex pricing. Whether you... View more
Organizer:
- Organized by
-
-
Tried Power Query for the first time
-
Tried Power Query for the first time
With some advice from @Doug McLean and following in the footsteps of @Vince I have dipped my toes into the waters of Power Query in Excel. I still have a few things to figure out, but this is going to be a huge data washing time saver for me!
Thank you both for posting all that you do about Power Query! Another great example of something that “I didn’t know that I didn’t know about”!
-
3 Replies
-
Points: 13,692Rank: UC2 Brainery Blue Belt III
Great news @David Cutler !
The only problem that you’ll have soon is finding enough ‘dirty’ data to wash! 😅
-
Points: 15,212Rank: UC2 Brainery Advanced Blue Belt
a lot of people don’t know about it (and even more don’t realize its free)
It really is one of the best tools out there for repeated data washing.
Just mind your steps, because it can error out easily. Its best to have a nice consistent output of data so that your columns names are all the same all the time. That is one big key to using Power Query. The other is a consistent name of your markup summary, which a BatchConfig file will allow you to do. This will allow you to make your file path a bit more dynamic if you like-
Points: 26,754Rank: UC2 Brainery Advanced Brown Belt
I think the “consistency” is where I was getting messed up yesterday @Doug McLean
Reading through some of your XCON materials I think what I need to do is setup a template file with the query in our “new project” directory template and save the exported file to the same directory every time with the same name every time… I have the export columns setup to be generated consistently, now I need to be more disciplined in my file naming…
-
Log in to reply.