Using multiple sheets with different Dates...Error

morenasm — Wed, 19 Feb 2020 16:12:29 GMT

Hi Guys

I hope someone can help me.

I am having trouble with my data. I have a QVD file that i am uploading with sales data and then i have an Excell file im uploading for all the Orders placed. Now both these files have their own relevant dates. I cant seem to get them working. It shows the dates when i build the report but when i select week or month or any time period at adss all the 'QTY Sold' Togther.

[Calendar]:
LOAD Distinct
Year([Cal Date]) as [Year],
Num(Month([Cal Date]),'00') as [Month],
Year([Cal Date]) * 100 + Month([Cal Date]) as [Num Period],
Dual(Monthname([Cal Date]),Year([Cal Date]) * 100 + Month([Cal Date])) as [Period],
MonthName(Date([Cal Date],'DD/MM/YYYY')) as [Year Month];
LOAD
$(vCalStartDate) + IterNo() - 1 as [Cal Date]
AutoGenerate (1)
WHILE $(vCalStartDate) + IterNo() - 1 < $(vCalEndDate);

Re: Using multiple sheets with different Dates...Error

Lisa_P — Wed, 19 Feb 2020 21:43:01 GMT

What does your data model look like ?

topic Re: Using multiple sheets with different Dates...Error in Connectivity & Data Prep

Using multiple sheets with different Dates...Error

Re: Using multiple sheets with different Dates...Error