topic Re: Text months converted to number after concatenating with nulls in App Development

Text months converted to number after concatenating with nulls

agustapia — Wed, 11 Aug 2021 21:13:37 GMT

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?

Re: Text months converted to number after concatenating with nulls

Lauri — Thu, 12 Aug 2021 14:54:04 GMT

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

Re: Text months converted to number after concatenating with nulls

agustapia — Thu, 12 Aug 2021 15:25:05 GMT

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