Forum Discussion

ad_w's avatar
ad_w
Frequent Visitor
1 year ago
Solved

Add Column for Fixed Month

How do I add a column with the date value for a specific month (not current month)

I have a monthly report that has 12months worth of data and need to compare the top 10 for each months report, the data within the report have their own dates which are not relevant to my outcome. Can I use folder names for the months? I need to add a column that has an assigned month that is not coming from data within the report

Need Help
  • ad_w's avatar
    ad_w
    1 year ago

    That was the idea, I ended up extracting from the file name as it contained the month and year

3 Replies

  • m_dekorte's avatar
    m_dekorte
    Resident Rockstar
    1 year ago

    Hi ad_w,

     

    When leveraging the Folder connector you could use the Folder Path column to extract part of a folder name. 

     

    Hope that helps.

    • ad_w's avatar
      ad_w
      Frequent Visitor
      1 year ago

      That was the idea, I ended up extracting from the file name as it contained the month and year

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi ad_w ,

     

    Agree with m_dekorte.

    In addititon, you can create a new column with a fixed month value. For example, if you want to assign the month of January, you can use the following formula:

    = "January"

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.