Applymap with time range

sifatnabil — Thu, 23 Oct 2014 02:33:58 GMT

Hi, thought I'd post this here:

I have data from an Oracle database, where there is a field called MSG_DATE_TIME which is of data type = "timestamp (6) with local time zone".

When the main table updates with a new row, the mapping table updates immediately after, with a few milliseconds delay, like 5 milliseconds. I want to map the FIXING_STATE, so the mapping load would be like this:

mapstate:

MAPPING LOAD

MSG_DATE_TIME & ' ' & DESCRIPTION,

FIXING_STATE

Resident mappingtable;

The problem is that the MSG_DATE_TIME in the main table and mapping table lag by 5 milliseconds. How can the mapping be done such that the applymap statement can accommodate the 5 millisecond lag time?

The logic would be something like this:

applymap('mapstate',MSG_DATE_TIME within 5 milliseconds & ' ' & DESCRIPTION)

Thanks.

topic Applymap with time range in QlikView

Applymap with time range