From the above, 1st data table is your daily transactions and 2nd data table is a master spreadsheet. i need to go and check each row and would then need to match column1 from databtable 1 with column 1 of datatable 2. IF there is a match i need to add the values (Column3) and write it back to Datatable1 as one entry. If no match it just moves on to the next row.
Is there any inbuilt functionality for me to do this? or is there a query i can run to get the desired outcome?
Thank you. Your activity Group By Aggregation SUM is awesome but it just leaves to column after sum. The key and the column to be summarised. I also need the other columns that are in the source DT. Any idea or am I using the activity incorrectly?