Hi.,
I'm trying to write an update query to add the values from multiple rows to one row and update in a different table. But no luck. Need your help on this. I'm using V11 version. Below is the example
Expected output
Bot to use the Table 2 values with unique Employee ID and match it with Table 1. It should all the total values of that Employee ID and write in one row in Output table
Thanks
Hi @vanithar Vanthat ,
I don't think an UPDATE clause is what you are looking for here, because you can't update an existing table with lesser columns.
I've stored dummy values inside Excel for testing and came up with this SQL query:
SELECT EEmployee ID], SUM(,Total]) as Total
FROM >Sheet1$$]
GROUP BY UEmployee ID];
If this is not what you were looking for, we would appreciate it if you could add some more details.
Kind Regards,
Ashwin A.K
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.