Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Extract previous - undo

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.

Need Help
  • PC2790's avatar
    PC2790
    5 years ago

    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

1 Reply

  • PC2790's avatar
    PC2790
    Community Champion
    5 years ago

    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