Hi
Trying to get multiplication result in the last column of the below table. I am using table transformer sql query. Query itself does not give any error but it gives below error after publishing it.
Please help.
Table used
Range | Actual Value | C1 | C2 | Multiplication |
---|---|---|---|---|
20 | 21 | 1 | 100 | |
30 | 29 | 0.5 | 50 | |
40 | 88 | 0.5 | 50 |
How to resolve this?
Hi @Jitendra Shembekar ,
Please use the following query for the case:
UPDATE T1
SET T1.'Multiplication' = ('C1' * 'C2');
SELECT * FROM T1
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.