Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Mapping load with 1 key for two fields

Hi all,

I have the following problem. I need to check wether a shipment is delivered within a certain timeframe (defined with a start and endtime) at a depot. The key for these depots are the day and the depot name. However for certain depots I have 2 timeframes for a day. Now I need a way to check for both time frames if the shipment is delivered within the time frame. Any help is greatly appreciated!

2 Replies
vincent_ardiet
Contributor III

Mapping load with 1 key for two fields

Hi,

Instead of a mapping load, have you try to join your shipment table with your depot table with IntervalMatch (using the extended syntax) ?

Considering that:

- Shipments and TimeFrames are loaded

- Shipments contains at least DepotName and DeliveredTime

- TimeFrames contains DepotName, Start and End

- TimeFrames can contain many lines with the same depot name

You will have a script like this:

Left Join (Shipments)

IntervalMatch (DeliveredTime, DepotName)

Load

  Start,

  End,

  Depot

Resident TimeFrames ;


Drop Table TimeFrames ;

Then, Shipments table will have two more fields Start and End. You can use those fields to create a flag if you don't want to keep them.

Regards,

Vincent

Not applicable

Mapping load with 1 key for two fields

Hi Vincent,

Thanks for your reply. It is partially correct since I also need to do an aggregation on Depot Level to determine if a shipment is in one of the timerframes.

Community Browser