Hi,
I need help from anyone who have the same situation, to write a script to create a table to be used on UI with the result of data from 2 transaction tables.
The idea is for each calendar day and product code I need to create a record on the new table with sales amount (from the sales transaction file) and the purchase amount for the same date from the purchase transaction file)
The result should be :
Date; ProdutcCode;SalesAmount;PurchaseAmount
I have data files with:
Product codes
Sales transactions
Purchase transactions
Thanks in advance,
José
