Hello,
I am using this guide to try an update columns in Table B based on input from Table A.
All the columns in question are of Decimal type but when I attempt to construct the “execute an action on a set of rows” My ref row expression keeps returning a column type error message. My expression is as followsSELECT(Incoming RM[Quantity Out],[RM Inv Id]=[_THISROW].[RM Inv Id])
. I can’t figure out where the discrepancy is in column type.
Any help would be appreciated
Solved! Go to Solution.
Hi Eli,
Is “Quantity Out” the key for table “Incoming RM”?
The “Referenced rows” property must return a set of key values.
Hi Eli,
Is “Quantity Out” the key for table “Incoming RM”?
The “Referenced rows” property must return a set of key values.
Just realized that now. Thanks for the clarification
User | Count |
---|---|
41 | |
25 | |
25 | |
17 | |
12 |