However, when then I go and check the data, I see that something is strange.
the dates are not joined properlly I would say. Why do I have 2 lines if the data is the same? this happens also for the other columns used for the join. Using the full join I expect to see only 1 column when they have the same date,
and one column null if a specific date is present in one dataset but not in the other one like here
yes, most of the time…but the problem is that in one dataset I have the data until today, and in the other dataset I have data untill today +2 weeks. Thus doing the inner join, will not create the problem but I will loose the today+2 weeks data.
I thought that a full join will act as inner join for the common fileds, but still keeping the rest withouth creating that strange behaviour when it seems that it joins correctly, but it still somehow duplicate the row…
