2 Replies Latest reply: Feb 27, 2018 4:19 AM by Kaushik Solanki RSS

    Inline help

    bhavani b

      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.

       

      Month Order.png

      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

      ];