Forum Discussion
Solved
mass update if add new column in the table that import from folder
Hello everyone, Aim to manage my files, I use Excel [Get Data] - [From File] - [From Folder] to import the filenames into Excel sheet. Then I add one new column in the end of the table, fill som...
Joey-G Indeed. When you add a column outside Power Query the information in that column is no longer synchronized when you refresh the query and when new files were added. Google for "self referencing query power query" and you'll find many resources describing how to deal with the issue. Pick one that suits you best. You could use the file name as a unique identifier to merge the query with its previous output that has the column added to it manually.
Joey-G Indeed. When you add a column outside Power Query the information in that column is no longer synchronized when you refresh the query and when new files were added. Google for "self referencing query power query" and you'll find many resources describing how to deal with the issue. Pick one that suits you best. You could use the file name as a unique identifier to merge the query with its previous output that has the column added to it manually.
Hello, Riny_van_Eekelen
Thanks a lot for your quick reply.Now I know there's not function for power query to sync other data just in worksheet, then I have to establish my base table and import into power query as reference.
Thanks a lot, wish you a nice day!
