Date field loading with two different formats

nkosinde13 — Wed, 24 Jul 2019 13:35:14 GMT

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

Re: Date field loading with two different formats

Miguel_Angel_Baeyens — Wed, 24 Jul 2019 14:31:05 GMT

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.

Re: Date field loading with two different formats

nkosinde13 — Thu, 25 Jul 2019 09:49:58 GMT

Thank you so much. It works perfectly now

topic Date field loading with two different formats in QlikView

Date field loading with two different formats

Re: Date field loading with two different formats

Re: Date field loading with two different formats