topic Re: Incremental load with date and time field in QlikView

Incremental load with date and time field

vireshkolagimat — Sun, 20 May 2018 12:05:07 GMT

Hi All,

I've sample data like attached image. The combined key (ShLocation+ShInvNo+ShInvDate) act as primary key.

To identify the last modified date, I am using ShlastSyncDate column which contains the time part as well.

If i only consider date part while doing the incremental reload then i will miss some transactions. how to deal in this case. can we convert the date into num or something to avoid loss of data.

Kindly provide some suggestions.

Thank you.

Regards,

Viresh

Re: Incremental load with date and time field

isingh30 — Sun, 20 May 2018 12:20:54 GMT

Did you try floor function with date? It will give you only data & not time.

Can you share data in excel file?

Thanks.

Re: Incremental load with date and time field

vireshkolagimat — Sun, 20 May 2018 12:30:24 GMT

Hi, yeah i got if i use the floor function, i can get rid of time part.

But i would like consider time part as well while doing the incremental load.

Please find the attached sample data.

Regards,

Viresh

Re: Incremental load with date and time field

isingh30 — Sun, 20 May 2018 12:41:20 GMT

Try like this - num(shInvDate) as Date. This will convert the date into num.

Thanks.