Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
I think you need to modify the field in the 3rd QVD, using the Month() function. Your load will be slower but not terribly.
I think you need to modify the field in the 3rd QVD, using the Month() function. Your load will be slower but not terribly.
Per your suggestion, I forced my null field to be a null month (Month(Null())) and that did the job. Thanks!