Forum Discussion

GUARACHA2C's avatar
GUARACHA2C
New Member
3 years ago

Refresh Info and from a query to intial query¡¡¡¡

Hello,

 

I'm trying to run a infrom but I got some problems to updated the data of the main data set.

 

So:

I got table 1 which is the main one

 

REFSStatuscomments
ref1createnormal 
ref2sentnormal 
ref3createnormal 

 

I got table 2

REFSother parameter
ref1same
ref2change 
ref3change 

 

I merge both 1 and 2  and dependif of the info some cells will change an other remain.

 

REFSStatuscommentsother parameter
ref1createnormal same
ref2Changeother change 
ref3Change other change 
New NewNewnew

 

The problem Is when I try to update the info that changed in the main dataset I'm been trying with customs but nothing.

(In SQL just you refenrece some colums and code UPDATE and that's all but power query not hahaha)

 

Sounds simple if you got a way to solve this would be appreciate it

1 Reply