Hi All,
Tried looking for the information i need but can’t seem to find it here. I need to do a group by with 2 different data tables.
DataTable 1
DataTable2
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?
Please advise
Thanks!
Brian