Forum Discussion
edit data in editqueries
In general, editing data in "Edit Queries" is done by using the rich library of Power Query functions and other Power Query language components, e.g. adding columns, replacing values etcetera.
If you really want to edit your data, it can only be done by creating a copy of your table and paste it in "Enter Data". There you can edit the data, but the copy will not be dynamically updated with any changes in the csv files.
My suggestion would be to edit the csv files (or use the rich library..... etcetera).
Here is a video that illustrates how to copy and edit data using "Enter Data":
So the variable in the link is BLUE?
you can generate a userdefined column
No, that link is image link for blue cricle image.
i want to update the previous link with the new link.
not add a new coloum, just edit in that row.
Sorry, if i missunderstand yor previous reply.
In general, editing data in "Edit Queries" is done by using the rich library of Power Query functions and other Power Query language components, e.g. adding columns, replacing values etcetera.
If you really want to edit your data, it can only be done by creating a copy of your table and paste it in "Enter Data". There you can edit the data, but the copy will not be dynamically updated with any changes in the csv files.
My suggestion would be to edit the csv files (or use the rich library..... etcetera).
Here is a video that illustrates how to copy and edit data using "Enter Data":
tq guys for your help. Really appreciate:smileywink: