mass update if add new column in the table that import from folder

Question

Hello everyone,&nbsp;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 some categories. I hope if there's new files saved in the folder, then I can refresh the Excel table and get the latest filenames list, and fill category for the new files.&nbsp;However, when I refresh the table, the rows are updated in a wrong way with my purpose, the cells of new column massed after update.&nbsp;How can I keep the rows as I maintained, and let the cells in new column blank for new added rows.I really need to solve this problem, appreciate if you can help.1. I import the filenames from folder to Excel2. I add new column in the end of the table, and fill some information&nbsp;3. I save 2 new files in the folder&nbsp;4. I refresh the table, and cells massed...&nbsp;properties:&nbsp;

riny_van_eekelen · Accepted Answer

Joey-G&nbsp;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.

Forum Discussion

mass update if add new column in the table that import from folder

Share

Resources