Forum Discussion

mshashmi's avatar
mshashmi
Frequent Visitor
9 years ago
Solved

Update table2 after updating first table1

Hi

 

I have two tables, table1 and table2.

Table2 is sorted form of table1. When I updated table1, the data in table2 remained the same. Is there any option to refresh data in table2 according to the new data in table1 or do I need to do sorting again in table2?

 

Thanks

Need Help
  • cs_skit's avatar
    cs_skit
    9 years ago

    If you create table2 entirely in PowerQuery (aka "Query Editor") based off of table1 it will be recreated each time you refresh table1.

1 Reply

  • cs_skit's avatar
    cs_skit
    Resolver IV
    9 years ago

    If you create table2 entirely in PowerQuery (aka "Query Editor") based off of table1 it will be recreated each time you refresh table1.