- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
why it not mapping properly
Hi all
i try to get hour field in master calendar but Master calendar link key is not mapping with Data Tables
What i did wrong? why its duplicated?
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this
GasResponse:
LOAD ISR_NO,
CREATED_DATETIME,
Timestamp(Floor(CREATED_DATETIME, 1/24),'MM/DD/YYYY HH') as MasCalLink,
Timestamp(Floor(CREATED_DATETIME, 1/24),'MM/DD/YYYY HH') as MasCalLink1,
RESPONSE_TIME
FROM
[try.xls]
(biff, embedded labels, table is Sheet1$);
Calendar:
LOAD Year(TimeStamp) as Year,
MonthName(TimeStamp) as MonthYear,
Month(TimeStamp) as Month,
Day(TimeStamp) as Day,
Date( Floor( Date(TimeStamp)),'MM/DD/YYYY') as Date,
Hour(TimeStamp) AS Hour,
Timestamp(Floor(TimeStamp, 1/24),'MM/DD/YYYY HH') as MasCalLink ;
LOAD
Timestamp($(vMinDate) + (RecNo() - 1)/24) as TimeStamp
AUTOGENERATE 23 * $(vDays);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That's because you only formatted the text representation, and the numeric part kept unchanged (and the numeric part is used for the key match).
try to adapt the numeric part, too, e.g.
Timestamp#(Timestamp(TimeStamp,'MM/DD/YYYY HH'),'MM/DD/YYYY HH') as MasCalLink
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this
GasResponse:
LOAD ISR_NO,
CREATED_DATETIME,
Timestamp(Floor(CREATED_DATETIME, 1/24),'MM/DD/YYYY HH') as MasCalLink,
Timestamp(Floor(CREATED_DATETIME, 1/24),'MM/DD/YYYY HH') as MasCalLink1,
RESPONSE_TIME
FROM
[try.xls]
(biff, embedded labels, table is Sheet1$);
Calendar:
LOAD Year(TimeStamp) as Year,
MonthName(TimeStamp) as MonthYear,
Month(TimeStamp) as Month,
Day(TimeStamp) as Day,
Date( Floor( Date(TimeStamp)),'MM/DD/YYYY') as Date,
Hour(TimeStamp) AS Hour,
Timestamp(Floor(TimeStamp, 1/24),'MM/DD/YYYY HH') as MasCalLink ;
LOAD
Timestamp($(vMinDate) + (RecNo() - 1)/24) as TimeStamp
AUTOGENERATE 23 * $(vDays);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Sunny,
How below code works
LOAD
Timestamp($(vMinDate) + (RecNo() - 1)/24) as TimeStamp
AUTOGENERATE 23 * $(vDays);
Can you please explain
Regards
Tripati
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
For a fixed series of vDays full day calendar entries (all hours), you may want to change the 23 into 24.