Author Topic: Two sets of data and need to join Queries (Relational)  (Read 89 times)

Offline HelloCognos

  • Community Leader
  • *****
  • Join Date: Mar 2018
  • Posts: 119
  • Forum Citizenship: +2/-0
Two sets of data and need to join Queries (Relational)
« on: 12 Oct 2018 11:18:16 am »
Hi, :) :)
I have two sets of data from two different namespace.

1) Includes all the cars that are in the garage and being worked on
2) Includes all the cars that have been done and fixed
3) Includes all the cars that the owner took them out before it was done.

Now, I need to build a Query that includes all the above 3 scenarios.

The data looks like what I have in the spreadsheet attached.

I need to get the total count of cars once they are Passed Quality Check that were still in the garage or took out by the owner. No matter if it was completed or Took out by the owner.

So, building different Queries based on different Statuses could work and I'm thinking once I have the Quality Check Query (Filter Status based on "Quality Check" and Join with the second Query based on the same CAR ID but the second Query will show all the instance of CAR and it's Statuses so the count can include all the CARs that passed the Quality Checked that were Took Out or Completed.

Is Join between the two Queries a possibility or I can do this within the same Query?

Thanks for your time.


Offline HelloCognos

  • Community Leader
  • *****
  • Join Date: Mar 2018
  • Posts: 119
  • Forum Citizenship: +2/-0
Re: Two sets of data and need to join Queries (Relational)
« Reply #1 on: 12 Oct 2018 01:46:05 pm »
So basically, just to clarify,  8)

1) Find any records that have passed the CAR Quality Check and their CAR ID
2) Identify the records from above based on their history of Completed, In Garage, Take out.
3) Show the counts in a Crosstab.

thanks

 


       
Twittear