Great video. I've been trying to figure out how to do this for hours and this is the only video with a solution that actually works. This is going to help my team at work immensely. Much appreciated.
Great video. Thanks. I am facing a problem where I am not sure what am I doing wrong but when I do step2 it loads only first column and rest of the columns are null when a file is added into a folder. I am pulling it from sharepoint which I dont think should make any difference
It does work- but everytime i refresh the excel an extra column is added , for example in your case , always another Paid column co,umns up everytime i refresh the data ? what is the solution?
Hi, So it works fine when there are no changes in data that manual cells are used. Im trying to have more dynamic data, by date, to filter them out and only display one date not all. Doing that this solution doesnt work. Is there any other work around? So that dates could be changed added or removed and it would display all dynamically?
So because it's a self-referencing table merge, it duplicates the "Columns", but if you just delete the initial duplicated column in the table OUTSIDE of power query, then it should solve the problem. Here's a video: th-cam.com/video/wHgv_gWw7iQ/w-d-xo.html&ab_channel=DougH
@@garyl3210 Hey, yes... academia had the solution, >>> but if you just delete the initial duplicated column in the table OUTSIDE of power query, then it should solve the problem
So because it's a self-referencing table merge, it duplicates the "Columns", but if you just delete the initial duplicated column in the table OUTSIDE of power query, then it should solve the problem. Here's a video: th-cam.com/video/wHgv_gWw7iQ/w-d-xo.html&ab_channel=DougH
Totally disagree... This is an AWESOME revelation for us and allows us to refresh the basic business systems status data automatically without losing our manually entered notes! Perfect for things that are too small for a fancy MSPROJECT implementation and keeps the info in Excel which is readily absorbed by even those who are not data geeks. TEEEEERRRIFFIC!
Great video. I've been trying to figure out how to do this for hours and this is the only video with a solution that actually works. This is going to help my team at work immensely. Much appreciated.
Great video, and probably the most concise and ordered one too.
Great video. Thanks.
I am facing a problem where I am not sure what am I doing wrong but when I do step2 it loads only first column and rest of the columns are null when a file is added into a folder. I am pulling it from sharepoint which I dont think should make any difference
Same issue - new rows only loading first column - rest are null
Same. Did anyone find a fix for this?
Same - when I add a new months worth of data, it loads the new record references but all the data is empty.
It does work- but everytime i refresh the excel an extra column is added , for example in your case , always another Paid column co,umns up everytime i refresh the data ? what is the solution?
Hi,
So it works fine when there are no changes in data that manual cells are used. Im trying to have more dynamic data, by date, to filter them out and only display one date not all. Doing that this solution doesnt work. Is there any other work around? So that dates could be changed added or removed and it would display all dynamically?
Question: why wouldn't you just merge the first query with the second query with the manual entry and just keep the manual column?
Mine keeps adding my extra column indefinitely every time I refresh it. Is there something I'm doing wrong?
So because it's a self-referencing table merge, it duplicates the "Columns", but if you just delete the initial duplicated column in the table OUTSIDE of power query, then it should solve the problem. Here's a video:
th-cam.com/video/wHgv_gWw7iQ/w-d-xo.html&ab_channel=DougH
I had the same, but the solution is very simple, NOT INTUITIVE , see the reply from above, thanks - @academia8884
Mine is doing this also, anyone found a fix?
@@garyl3210 Hey, yes... academia had the solution, >>> but if you just delete the initial duplicated column in the table OUTSIDE of power query, then it should solve the problem
Mine keeps adding columns as well?
So because it's a self-referencing table merge, it duplicates the "Columns", but if you just delete the initial duplicated column in the table OUTSIDE of power query, then it should solve the problem. Here's a video:
th-cam.com/video/wHgv_gWw7iQ/w-d-xo.html&ab_channel=DougH
This is one of those use cases where the solution is worse than the problem.
Totally disagree... This is an AWESOME revelation for us and allows us to refresh the basic business systems status data automatically without losing our manually entered notes! Perfect for things that are too small for a fancy MSPROJECT implementation and keeps the info in Excel which is readily absorbed by even those who are not data geeks. TEEEEERRRIFFIC!