3 Replies Latest reply: Mar 17, 2015 9:59 AM by Henric Cronström RSS

    question about creating a new field while loading data

    Larisa Filonova

      Hi,

      I have a field Month in my source data. My task is to generate a new feld named Quarter based on the Month field.

       

      So, while loading data I'd like to set the following condition:

      - for values Jan, Feb, Mar generate value Q1 in the Quarter field

      - for values Apr, May, Jun generate value Q2 in the Quarter field

      - for values Jul, Aug, Sep generate value Q3 in the Quarter field

      - for values Oct, Nov, Dec generate value Q4 in the Quarter field


      Which operators should I use to implement it?


      Thank you in advance,


      Larisa