Text months converted to number after concatenating with nulls

[agustapia]

Hi all,

I have three different tables in qvd format, each of them have the exact same dimensions, including a dimension that stores the month in two of them, and in the other one is null.

When I load only the tables with the full month dimension, the month is displayed as text (which is how I want it), but when I load the three of them and they auto concatenate, the month is displayed in number format.

I don't want to force the month to be text in the script because I wouldn't be able to sort it as month and the load wouldn't be optimized anymore.

Is there anything else I can do?

[Lauri · Accepted solution]

I think you need to modify the field in the 3rd QVD, using the Month() function. Your load will be slower but not terribly.

[agustapia]

Per your suggestion, I forced my null field to be a null month (Month(Null())) and that did the job. Thanks!