Inline help

[bhavvibudagam]

Hi Experts,

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.

Table:

load

dateField ,

Month(dateField) as Month,

(Date(monthstart(dateField), 'MMM-YYYY')) as MonthYear,

'Q' & ceil(month(dateField)/3) as Quarter;

load

date(Timestamp#(timestampField,'DD/MM/YYYY hh:mm')) as dateField;

load * Inline [

timestampField

04/12/2017 11:57

04/12/2017 14:40

07/12/2017 12:58

08/01/2018 17:22

08/11/2017 13:24

10/11/2017 14:25

11/12/2017 16:00

];

left Join(Table)

Load * inline [

Month,MonthOrder

Jan,1

Feb,2

Mar,3

Apr,4

May,5

Jun,6

July,7

Aug,8

Sep,9

Oct,10

Nov,11

Dec,12

];

[agigliotti]

you don't need any script to order for month, simple order it numerically asc.

[kaushiknsolanki · Accepted solution]

Hi,

Change below section in your script

Text(Month(dateField)) as Month,

This will work.

Looking at your data and the way Month field is created, I dont think you need separate sorting for Month.

Regards,

Kaushik Solanki