Discussion Board for collaboration related to QlikView App Development.
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.
Go to 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.
View solution in original post
Thank you so much. It works perfectly now