Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Skip the ticket, Chat with Qlik Support instead for instant assistance.
Showing results for 
Search instead for 
Did you mean: 
Partner - Contributor III
Partner - Contributor III

Timestamp# joining two fields to create a timestamp

I have a series of text files delimited by white space something like this:

16/01/15 20:45:56

16/01/15 21:50:13

I want to join the two fields together to create a timestamp field from which I can build an incremental load strategy/script. I have tried various things using date,num,timestamp,timestamp#,makedate#floor and the most I achieve is either a string of data which qlikview will only recognise as a string and not a timestamp, or a number which Qlikview doesnt recognise as a date.

Anyone got any ideas??

10 Replies
Contributor II
Contributor II

Oh Nitesh,

Did that ever help. You just solved what my reading all morning did not!!