topic Re: Date conversion for Twitter Data in QlikView

Date conversion for Twitter Data

marco_puccetti — Tue, 19 May 2015 09:04:53 GMT

Hello i need to get the twitter creation date, and this is the format:

How can i convert the Search_created_at in a comparable date in qlikview?

Thanks

Marco

Re: Date conversion for Twitter Data

Ralf-Narfeldt — Tue, 19 May 2015 09:40:22 GMT

Maybe a stupid question, but can't you use the following two fields that provide a more recognizable timestamp and date? Or maybe they are not availble to you?

Re: Date conversion for Twitter Data

marco_puccetti — Tue, 19 May 2015 10:53:44 GMT

I can use the 4th column perhaps it can be usefull to do it.

Thanks

Marco

Re: Date conversion for Twitter Data

Ralf-Narfeldt — Tue, 19 May 2015 11:22:45 GMT

Indeed it will be more useful.

If you still have problems interpreting that as a date due to your local date settings, this should interpret it correctly:

Date(Date#(Search_created_at_d, 'DD-MMM-YYYY')) As Search_created_at_date

Search_created_at_d would be the name of that 4th column, it's shortened in that picture...

Please mark as Helpful or Answered if you are happy with the answer

Re: Date conversion for Twitter Data

marco_puccetti — Tue, 19 May 2015 12:19:05 GMT

It doesn't work.

Marco

Re: Date conversion for Twitter Data

Ralf-Narfeldt — Mon, 25 May 2015 05:53:41 GMT

How does your script look like at the moment?

Re: Date conversion for Twitter Data

marco_puccetti — Mon, 25 May 2015 07:47:12 GMT

I'm working about it.

Marco

Re: Date conversion for Twitter Data

timanshu — Mon, 25 May 2015 09:58:50 GMT

Load Date(Date#(TempDate, 'DD-MMM-YYYY hh:mm:ss')) as Date;

Load

subfield(Search_created_at,' ',3) & '-'

subfield(Search_created_at,' ',2) & '-'

subfield(Search_created_at,' ',6) & ' '

subfield(Search_created_at,' ',4)

from test.xlsx

as TempDate

Re: Date conversion for Twitter Data

Mon, 01 Feb 2016 20:46:26 GMT

Hi,

i am having the same problem. How do I solve it?

Re: Date conversion for Twitter Data

Mon, 01 Feb 2016 21:01:33 GMT

Hi,

subfield is howing error.