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
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:
Excellent, that's working now, superbe, thank you !
Laurent
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
I did it few minutes ago. I did not know it existed...
Laurent