topic Re: RSS Date format in Qlikview in QlikView

RSS Date format in Qlikview

Anonymous — Sun, 07 Feb 2016 00:04:58 GMT

Hi,

I have imported the MS Office 365 rss feed into qlikview, but I have a problema with the date format.

Qlikview is not identifying it as a date format, just as normal text, so I cannot apply expressions that filter these dates such as just showing today's records, for example.

Feed:

http://rss.servicehealth.microsoftonline.com/feed/pt-PT/B7F70D7F85F11C8825780A4D1A857937/8p4qc7/gk1n7d/eqnn6d/n-dbvo/0p0_9d/o4u3yj/pqt52y/x9duf_/c8mfak

Can someone tell me how can I do that please?

Attached the file. Thanks for the help!

Re: RSS Date format in Qlikview

MK_QSL — Sun, 07 Feb 2016 08:47:04 GMT

Load your tables as below...

item:

Load

TimeStamp(TimeStamp#(Left(Trim(SubField(pubDate,',',-1)),20),'DD MMM YYYY hh:mm:ss')) as DateTimeField,

Date(Floor(TimeStamp#(Left(Trim(SubField(pubDate,',',-1)),20),'DD MMM YYYY hh:mm:ss'))) as DateField,

Time(Frac(TimeStamp#(Left(Trim(SubField(pubDate,',',-1)),20),'DD MMM YYYY hh:mm:ss'))) as TimeField;

LOAD link,

title,

description,

pubDate,

%Key_rss_48AB09FE9E3B67F7 // Key to parent table: rss

FROM [http://rss.servicehealth.microsoftonline.com/feed/pt-PT/B7F70D7F85F11C8825780A4D1A857937/8p4qc7/gk1n7d/eqnn6d/n-dbvo/0p0_9d/o4u3yj/pqt52y/x9duf_/c8mfak] (XmlSimple, Table is [rss/channel/item])

;

Re: RSS Date format in Qlikview

Anonymous — Sun, 07 Feb 2016 15:40:19 GMT

It works ! Many Thanks!