Extract previous - undo

[Anonymous]

Hello,

Is there a way to reverse this process? I right clicked on an applied step and selected Extract Previous to a new table. I would like to revert these steps back to my original table and remove the table which was created in this process.

Thank you.

[PC2790 · Accepted solution]

Hello @Anonymous ,

1) Go to advanced editor of the new table created and copy the steps between 'let' and 'in'.

2) Now go back to your main table and there will be the first line which will be somethin line:

Source = <NewlyCreatedTable"

3) Replace this with the copied lines in the step 1 and other cosmetic changes in the existing step of the main table

4) See if the main table is back to its original shape.

5) Once you are statisfied, delete the new table

I don't think there is a direct undo provision provided.

You can also close the Power Query Editor without svaing the changes if you can afford losing any other changes made.

This will revert everything to the original position

Thanks