Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
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
 
					
				
		
 MarcoWedel
		
			MarcoWedel
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
some possible solutions without joining:
hope this helps
regards
Marco
 maxgro
		
			maxgro
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		load scheduled runs
then load actual run where exists(Name)
 
					
				
		
 alexandros17
		
			alexandros17
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Inner Join instead of left join will return only records contained in both tables
 petter
		
			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
		
			MarcoWedel
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
some possible solutions without joining:
hope this helps
regards
Marco
 
					
				
		
Thank you Marco, very much appreciated!
 
					
				
		
 MarcoWedel
		
			MarcoWedel
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		you're welcome
regards
Marco
