Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

nkosinde13
New Contributor III

Date field loading with two different formats

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

 

 

 

 

 

1 Solution

Accepted Solutions

Re: Date field loading with two different formats

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

2 Replies

Re: Date field loading with two different formats

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

nkosinde13
New Contributor III

Re: Date field loading with two different formats

Thank you so much. It works perfectly now