Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

import time (importa time)

Hello everybody

I need help !!!

in the script of the import stage I create a table with the name now that the field has to be extracted from the field name AAORA

here is the script

tab2:

LOAD

*,

Year (Date # (DATA, 'YYYYMMDD')) as YEAR,

Month (# Date (DATE, 'YYYYMMDD')) as MONTH

Day (Date # (DATA, 'YYYYMMDD')) as DAY,

Hour (Time # (CCORA, 'hhmmss')) AS NOW,

Minute (Time # (CCORA, 'hhmmss')) AS MINUTES,

Second (Time # (CCORA, 'hhmmss')) AS SECONDS

Now it happens that the dates the matter properly instead mind the hours are not exactly what I find on db

example

in db time is 94547

import finds to 23

someone can tell me why

thanks 1000

Translated with Google Translate - Qlik Community Administrative Team

Ciao a tutti

ho bisogno di aiuto !!!

nello script della fase di importazione creo una tabella con il nome ora tale campo deve essere estratto dal nome campo AAORA

ecco lo script

Tab2:
LOAD
*, 


Year(Date#(DATA, 'YYYYMMDD')) as ANNO,
Month(Date#(DATA, 'YYYYMMDD')) as MESE,
Day(Date#(DATA, 'YYYYMMDD')) as GIORNO
Hour (Time# (CCORA,'hhmmss')) AS ORA,
Minute(Time# (CCORA,'hhmmss')) AS MINUTI,
Second(Time# (CCORA,'hhmmss')) AS SECONDI,

Ora succede che le date le importa in modo corretto mente invece le ore non sono esattamente quello che trovo su db

esempio

nel db l'ora è                            94547

nell'importazione la trova alle   23

qualcuno mi sa dire perché

grazie 1000

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

Ciao Luca

prova

Hour(Time#(Num(CCORA,'000000'),'hhmmss'))

Saluti,

Antonio

View solution in original post

2 Replies
antoniotiman
Master III
Master III

Ciao Luca

prova

Hour(Time#(Num(CCORA,'000000'),'hhmmss'))

Saluti,

Antonio

View solution in original post

Not applicable
Author

GRAZIE FUNZIONA !!!!