This content has been marked as final. Show 2 replies
Can any one please help me on below issue.
I have extracted the Month from the date field.
Then to give the order to Month I have used the below inline script.
When I have tried to left join below inline table with the main table based on Month field then the Month order is not assigned to Month.
Showing blank I need to get 1.11,12 instead of Null.
Also when I have taken Max(Month) its showing 12. I think the month is not converted properly. Please help me on this.
Please find the below script and attached app.
Month(dateField) as Month,
(Date(monthstart(dateField), 'MMM-YYYY')) as MonthYear,
'Q' & ceil(month(dateField)/3) as Quarter;
date(Timestamp#(timestampField,'DD/MM/YYYY hh:mm')) as dateField;
load * Inline [
Load * inline [