Problem with data structure

Mon, 12 May 2014 10:37:40 GMT

Hi,

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

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

Re: Problem with data structure

Mon, 12 May 2014 11:01:24 GMT

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