Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nkosinde13
Creator
Creator

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
Miguel_Angel_Baeyens

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
Miguel_Angel_Baeyens

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
Creator
Creator
Author

Thank you so much. It works perfectly now