TBM Framework & Taxonomy

Hello, guys.

I am trying to include the date partition step in a new table that I have.

The column Competencia (Month that each row refers) is configured as 201701, 201702, ...,201801, 201802, 201803, ..., 201812.

I've tried to adapt them to date format, for this I tried some formulas like these:

Have anyone ever gone through something similiar? Could you help me?

Thank you.

Hola Pedro!

Try this formula instead ={Mes}&"/01/"&{Ano}

When you add && in between field it will create a "-" instead.

Let me know if this works!

Hi, Richard Coronado.

I got it extracting month from the first data (using Right), after that I created a auxiliar table "from/to", giving me the three first letters of the month. So I consolidated the name to year and date partition worked. Look it.

December FY2018 is selected:

Thank you for your help.

Hi Pedro, I'm glad to see that Richard's suggestion worked for you. As an FYI, you are receiving that error in your "Mes Ingles" column because because TBM studio doesn't allow for string manipulation within a Lookup() function. If you find the need to revise that you can go to your target table and concatenating the strings in a column there and then revise the Lookup() function contents to retrieve your newly created column.