topic Re: Re: How to join two tables with date? in QlikView

How to join two tables with date?

rcandeo — Wed, 30 Oct 2013 18:42:12 GMT

Hi, I have two tables like these:

Worker:

Name,

DateTime_Initial,

DateTime_Final,

Equipment

Production:

Equipment,

Date_Time,

Lot_Number

The first table has the names of the workers for each of the equipments in each date/time. It won´t happen to have more than a worker in the same equipment in the same date/time

The second table has the production of each equipment and it will have dozens of lines for each equipment by hour.

I need to have just one table linking the worker with the production, so I´ll know in the end wich is the production for each worker.

I´ve tried to use interval match but I don´t know how to put the equipment in the logic.

Best

Robson

Re: How to join two tables with date?

ronaldocarrijo — Wed, 30 Oct 2013 19:02:36 GMT

Use this:

Re: How to join two tables with date?

rcandeo — Wed, 30 Oct 2013 19:31:51 GMT

Hi, Look your table that didn´t work. The result is

Name	Equipment	Date_Time	DateTime_Initial	DateTime_Final	Lot_Number
A	X	01/01/2013 15:00:00	01/01/2013 12:00:00	01/01/2013 18:00:00	1
A	X	01/01/2013 19:10:00	01/01/2013 12:00:00	01/01/2013 18:00:00	2
B	X	01/01/2013 15:00:00	01/01/2013 18:00:01	01/01/2013 22:00:00	1
B	X	01/01/2013 19:10:00	01/01/2013 18:00:01	01/01/2013 22:00:00	2
C	Y	02/01/2013 13:40:01	02/01/2013 18:00:01	01/01/2013 22:00:00	4
C	Y	02/01/2013 18:30:01	02/01/2013 18:00:01	01/01/2013 22:00:00	3

This table have a duplication for lot number 1 and 2.

Lot number one should be with worker A only and lot two with worker B only.

Re: How to join two tables with date?

rcandeo — Wed, 30 Oct 2013 21:19:02 GMT

anyone can try to help me please?

Re: Re: How to join two tables with date?

ronaldocarrijo — Wed, 30 Oct 2013 23:58:12 GMT

Sorry, this right now:

Re: How to join two tables with date?

rcandeo — Thu, 31 Oct 2013 00:26:44 GMT

Thank You Very Very Much!