Matching Multiple Instances Issue

[#1]

Hello,

I've got two tables, one with a schedule, and one with a list of runs. They both have 'Name' as a key, and I've been trying to use a left join to match them. This has worked to get a list of all the Scheduled Runs and a Count of how many Actual Runs have taken place against it.

However I need to get a table that contains a list of Actual Runs - but only those that are contained in the Scheduled Runs table. So in the example below, I need a table containing all the instances of "Run1" and "Run2".

Scheduled Runs

Name	Description	Scheduled Start Time	Scheduled End Time
Run1	ABC	13:14:15	15:45:18
Run2	ABC	13:14:15	15:45:18
Run3	ABC	13:14:15	15:45:18
Run4	ABC	13:14:15	15:45:18

Actual Runs

Name	Status	Actual Start Time	Actual End Time
Run1	C	13:14:15	15:45:18
Run1	C	13:14:15	15:45:18
Run1	F	13:14:15	15:45:18
Run2	F	13:14:15	15:45:18
Run2	C	13:14:15	15:45:18
Run6	C	13:14:15	15:45:18
Run7	C	13:14:15	15:45:18

Any assistance is greatly appreciated.

Kind regards,

Tristan Breslin

[maxgro]

load scheduled runs

then load actual run where exists(Name)

[alexandros17]

Inner Join instead of left join will return only records contained in both tables

[petter]

You can create a straight table with

One dimension:

     Name

One Expression:

     If(Count({<Status={A,C,F}>}Name)>0 AND Count({<Description={"*"}>} Description)>0,Count(Status))

[MarcoWedel · Accepted solution]

Hi,

some possible solutions without joining:

hope this helps

regards

Marco

[#6]

Thank you Marco, very much appreciated!

[MarcoWedel]

you're welcome

regards

Marco