Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Thank you so much. It works perfectly now