Update records hourly basis

[VKG]

Hi, 

I have a data set of Orders where each order passes certain queues before it complete. These queues has Queue Codes. So data set is like - 

Order           Queue

ab12               A

sb13               B

bd15               A

sf34                 C

Now, I have a hourly data feed available in my qvd from Data warehouse that have latest queue code of respective order and new orders created each hours. 

Similar to this - 

Order           Queue

ab12               B

sb13               C

bd15               B

sf34                 D

Sr21                A

I am trying to build a dashboard which will show  orders in each queue and refresh hourly basis. What should be my logic in qlik sense (Jun'18 release). 

I was thinking about incremental load but I don't have timestamp in any of data. Please suggest  logic to complete my task. 

Thanks

VKG 

[JordyWegman]

Hi VKG,

You can use the Timestamp() function from Qlik for this. Use this when you get the table from the Data warehouse and store it with the time stamp in a QVD.

Then get this per hour and set your task to run every hour in the QMC.

Jordy

Climber