DATA MODELING ISSUES WITH MULTIPLE DATE

[rupeshshah]

HI ALL,

i have a excel file there are all table has date,

how to make data model with connect master calendar connect all date

[stevedark]

Hi @rupeshshah 

I always find the best way is to create the calendar inline with the load, like this:

LOAD
  [Asset ID],
  [Asset Name],
  [Lot Size],
  Country,
  [Asset Status],
  [Ownership %],
  Date([Last Updated], 'DD MMM YYYY') as [Last Updated],
  Date(MonthStart([Last Updated]), 'MMM-YYYY') as Month,
  Month([Last Updated]) as [Month Name],
  Year([Last Updated]) as Year
FROM [lib://MyLibrary/Real Estate Data.xlsx]
(ooxml, etc.);

You can carry on adding as many date parts as you like to the script, finding WeekDay, Quarter etc. etc.

Cheers,
Steve

[rupeshshah]

HI @Stevedark

Thanx for give me soluation.

Rupesh