Date field loading with two different formats

[nkosinde13]

Hi All

One of the fields in my data set is a date that I'm creating , see below:

if(Month = 'JAN', '201901',
IF(Month = 'FEB', '201902',
IF(Month = 'MAR', '201903',
IF(Month = 'APR', '201904',
IF(Month = 'MAY', '201905',
IF(Month = 'JUN', '201906',
IF(Month = 'JUL', '201907',
IF(Month = 'AUG', '201908',
IF(Month = 'SEP', '201909',
IF(Month = 'OCT', '201910',
IF(Month = 'NOV', '201911',
IF(Month = 'DEC', '201912'
)))))))))))) AS Month_Date,

Then when I resident the data and load to a qvd, I format the field as below:

date(date#(Month_Date,'YYYYMM'),'MMM-YYYY') AS Month_Date,

But now when I load the data from the qvd into my model, the field comes out with both formats i.e. one from the created field and the other from loading into a qvd. See attached screenshot:

What is causing this issue?

Any help will be appreciated.

Thanks

Matlotlo

[Miguel_Angel_Baeyens · Accepted solution]

Perhaps the RESIDENT load is causing a concatenation if both tables have the same fields? 

Use NOCONCATENATE prior to the LOAD ... RESIDENT and store this table into the new file.

[nkosinde13]

Thank you so much. It works perfectly now