11 Replies Latest reply: Jun 30, 2017 4:53 AM by Alison Cooke RSS

    Creating Quarters Field

    Alison Cooke

      Hello Everyone,

       

      I am looking for some advice on how to create a quarters field.

       

      To give you some background, I have a script that looks like this, it's pretty simple:

       

      Screenshot (7).png

      So, I had a number of tables which each have tables for Employee ID, Gender and Current Job Title. Each table pertain to a different month so I used the FileBaseName function to generate a field based on the name of the excel document.

       

      Now, would it be possible to generate a field called quarters?

       

      If you could, please provide an explanation of how your expression works, as this is just a test and I'd like to be able to apply the solution myself to other data sets.

       

      Thank you in advance,

      Alison