Add Column for Fixed Month

[ad_w]

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

[Anonymous]

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.

[m_dekorte]

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 · Accepted solution]

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