How to update a value in a second table without being related

I have 2 unrelated tables, table A only has one row with two fields, I need to be able to take the value of the "concept" field and update it in table B in a set of rows filtered by status, could you help me with an example of as actions should be, thank you

Solved Solved
0 3 157
1 ACCEPTED SOLUTION

Create an Action :

Set some columns values to a row. 

[Xxxxxx field name ] = " values what ever you want to update may be concept field in table A.  " You can use select () expression for it. 

Action Condition : [status] = YYYY

View solution in original post

3 REPLIES 3

Can be done... Please share  screen shots of 2 tables.

 

These are the tables

Table A (Source)Table A (Source)

 

Table B (Target)Table B (Target)

 

Create an Action :

Set some columns values to a row. 

[Xxxxxx field name ] = " values what ever you want to update may be concept field in table A.  " You can use select () expression for it. 

Action Condition : [status] = YYYY

Top Labels in this Space