topic Re: Converting text to date format while importing from web in QlikView

Converting text to date format while importing from web

Sat, 22 Feb 2014 02:06:50 GMT

Hello,

I was able to connect to Alerts and Warnings and pull in the table containing Date, Type, and Location. My issue is that the Date is not returning as a date field in Qlikview. I have tried using Data(Date# and other methods but none have completed the task. I am able to connect to it via Excel and it easily recolonizes the date as a date field, not sure how to correct this. Any help would be great! Thank you

Re: Converting text to date format while importing from web

hic — Wed, 26 Feb 2014 07:14:43 GMT

You need to tell QlikView what the long Month names are... Do the following

Set LongMonthNames =

'January;February;March;April;May;June;July;August;September;October;November;December';

LOAD Type,

Date#(Date,'MMMM DD, YYYY') as Date,

Location

FROM [http://travel.state.gov/content/passports/english/alertswarnings.html]

(html, codepage is 1252, embedded labels, table is @1);

The MMMM maps against the LongMonthNames.

HIC

Re: Converting text to date format while importing from web

Tue, 04 Mar 2014 16:03:07 GMT

Thank you!