Key date

[Former Member]

Hi I have stock data snapshot stored on the daily basis represented as key date . I also have sales data on invoice date, If I combine the two views then universe/lumira is requesting for key date and data loads only for same. Is it anyway to avoid this short coming? Ben

[TammyPowlas]

Hi Ben - can you share some screenshots of the data and how you are joining?  Use the camera icon to upload an image

[Former Member]

Hi Tammy I am joining as follows Stock table .key date WITH  sales table.invoice date kindly advise

[TammyPowlas]

I'd have to see it; for example, are there duplicates of stock and dates?