Aris mashzone - merge a year field and month field to get a date ? How ?

Last activity on October 1, 2023 - 11:21 17.3k Views 4 Replies Professional ARIS

Laurent Bondon on September 2, 2010

Hi every body,

I am dealing with a data source in mashzone that contains one column with a year (4 digits) and one with a number representing the month (between 1 and 12).

I'd like to have a additional column giving a date field that would be the merge of the two previous column. I am trying with duplicate, arythmetics, ... No success so far.

Can you help me ?

Laurent

Bookmark

Notify Moderator

4 Replies

Markus von den Driesch on September 3, 2010 - 11:47

Hi,

try this: leave year and month columns as text in the data source, then concatenate both columns and finally apply the change data type operator on the concatenated column:

or register to reply.

Notify Moderator

Laurent Bondon Author on September 3, 2010 - 14:36

Excellent, that's working now, superbe, thank you !

Laurent

or register to reply.

Notify Moderator

Christian Neu on September 3, 2010 - 14:55

By the way, you would increase the help of the community and also get important news about MashZone, if you join the MashZone group. There are more people who attend to it. :-)

Best regards,

Christian

or register to reply.

Notify Moderator

Laurent Bondon Author on September 3, 2010 - 14:56

I did it few minutes ago. I did not know it existed...

Laurent

or register to reply.

Notify Moderator

Upcoming events

There are currently no upcoming events.

All events