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.
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?
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
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: ua-cam.com/video/wHgv_gWw7iQ/v-deo.html&ab_channel=DougH
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: ua-cam.com/video/wHgv_gWw7iQ/v-deo.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
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.
Question: why wouldn't you just merge the first query with the second query with the manual entry and just keep the manual column?
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?
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
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:
ua-cam.com/video/wHgv_gWw7iQ/v-deo.html&ab_channel=DougH
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:
ua-cam.com/video/wHgv_gWw7iQ/v-deo.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
This is one of those use cases where the solution is worse than the problem.