Forum

How to check which ...
 
Notifications
Clear all

How to check which rows were customized in the same table ?

3 Posts
1 Users
0 Reactions
148 Views
(@jaryszek)
Posts: 177
Reputable Member
Topic starter
 

Hi Guys,

i have table like here:

Key|SecondKey|Col1|Col2

Key1 SecondKey1 Dog Black
Key2 SecondKey2 Cat White

Keys are: "Key" and "SecondKey".

and now i want to check if user edited Col1 or Col2. 

How can i do this? I have only one table...

Best,
Jacek

 
Posted : 19/08/2021 5:31 am
(@jaryszek)
Posts: 177
Reputable Member
Topic starter
 

Generally with VBA i could create a copy of table somewhere and check differences. 

But it is possible within Power Query only? Just create temporary table ? Or table inside power query and block refreshing? 

Best,
Jacek

 
Posted : 20/08/2021 5:04 am
(@jaryszek)
Posts: 177
Reputable Member
Topic starter
 

I do not think so it is possible without having copy of table.

Best,
Jacek

 
Posted : 28/08/2021 5:47 am
Share: