Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Problem with data structure

Hi,

I have a problem with my data. It has the following structure

NameTimestampno of
K12013-09-01 03:00:00.0006
K12013-09-01 04:00:00.0005

the problem is that the given hour is wrong; it should be 02.00 instead of 03.00. All "no of" needs to be moved "up"

Is there an easy way to fix this i qlikview?


I thought about some sort of if-statement at first, but it got complicated since there was a lot of special cases.

I have about 35 excel files with the same kind of structure. I thought about writing a macro in excel and fix the problem there instead

At the moment I'm using Hour(Timestamp) to get the hour from the timestamp filed

1 Reply
Not applicable

Re: Problem with data structure

Hi Anna,

Please give more details. May you show more rows of your source table data and how those rows should look like after transformation?

regards

Darek