Sunny T <span class="icon-status-icon icon-mvp" title="Mvp"></span> wrote:
If Date and Hour are already interpreted as Date and Hour by QlikView, then why not just this
TimeStamp(Date + Hour) as Testing
I guess you want to use something like
Timestamp(Date + Hour / 24) as Testing
if Hour is already in range 0 to 23, like returned from Hour() function.
Or formatted as requested:
Timestamp(Date + Hour / 24, 'DD/MM/YYYY hh') as Testing
Date and Hour need to be fields in your input table, you may want to use a preceding load if both fields are just created in the same LOAD statement you want to modify.