Issues with date

[anagharao]

Hi Everyone,

I have a master calendar QVD (With 20 yrs of date) and i am trying to filter this according to the dates in Fact table. I'm using Keep to do so, and it works well.

However, I need the Month for an entire year displayed even if the Fact table does not have these dates.

I've attached an example below. The expected out come out be year as in fact but all months.

Regards,

Anagha

[jonas_rezende]

Hi, Anagha Rao.

Instead of using LEFT KEEP, do association through the key field. Example:

FACT:

LOAD

    Date     as %Date,

     Amount

FROM

\\svrin000mbp00.asia.corp.anz.com\umeshraa$\Desktop\Example.xlsx

(ooxml, embedded labels, table is Fact);

CALENDAR:

LOAD

    Date as %Date,

     Year,

     Month

FROM

\\svrin000mbp00.asia.corp.anz.com\umeshraa$\Desktop\Example.xlsx

(ooxml, embedded labels, table is Calendar);

Hope this helps!

[anagharao]

Thank you for the reply.

However this does not show all the months for a Financial year. I would like to see all months of a yr even if there are no data in the Fact table. I would also want the year to be as in the Fact table.