I have two tables , table A with forecast data and table B with occured registrations, with a common key. In both tables exists a datefield. The datefield in table A is dates for action that are predict to happen, from the case start to end and date in table B are those that actually occured.
Now I want to join the tables and put the dates in the same field. But whenever a predicted date also has been registrated as occured, I want to only keep the occured.
That becasue then I can use dates in table A to do a forecast and the dates in table B shows what the real numbers/actions after wich it accours. Whenever a date that are predicted to happen do happen it´s no longer any interest to know the prediction and it´s costs.
Maybe there are a better way to deal with it? I´m opend to any suggestions. The result should be a table that up on to registrated date show the registrated cost and then forward the predicted cost in diffrent colors.
Attaced a sample data with two keys
Edit. I don´t know why but my attached qvd gets a .xml after. remove it from filename and it´s qvd
Do a left join between the two tables.So that the occurred registrations are present in the final table and predicted data(but not occurred ) are also present in the final table.
