I have these two datasets that I want to link together.
Dataset 1 contains column units sales by specific EAN and Etailer in a specific week.
Dataset 2 contains customer ( = etailer), SAP sku (=EAN) and month (=actually week data as is dataset 1), unit sales sell in.
I want to combine this to one data source, do I need to make a specific key in both datasets to link them together and what would that be?
dataset 1:
dataset 2:
Dataset 1 contains column units sales by specific EAN and Etailer in a specific week.
Dataset 2 contains customer ( = etailer), SAP sku (=EAN) and month (=actually week data as is dataset 1), unit sales sell in.
I want to combine this to one data source, do I need to make a specific key in both datasets to link them together and what would that be?
dataset 1:
dataset 2: