I have problem with the data that i take from 2 tables when i left join them
FROM SALES_PER_QTY.QVD (qvd);
left join (table1)
FROM SALES_2017.QVD (qvd);
in the first table i have collected the summary of qty per store and item of the last 30 days and in the second table i have
the sales per date, store, item and qty.
I want to have all the items per store from the first table and the fields SALES_DATE and SALES_QTY from the second and where there is no sale_qty from the second table to have null values in SALES_DATE and in SALES_QTY.
With the script above i have only the common data and i don't know why.
I have think also the idea of applymap but i haven't find the correct code to do it.
I have tried this but i take all the data from the table that i have the sales per date and i want all the items per store from the first table to join with the items of the second and for the unmatching items to give me null values