In this role, we often need to combine large datasets. Suppose you’re given two datasets Company Locations, with the col
Posted: Thu Jul 14, 2022 2:17 pm
In this role, we often need to combine large datasets. Supposeyou’re given two datasets Company Locations, with the columnsCompany ID and Location, and Company Headcount, with the columnsCompany ID and Headcount.
Assume for now that each company ID shows up in bothtables. What tools would you use?
Depending on the tool, what function/syntax/query would you use?Suppose Company Locations has company IDs that don’t appear inCompany Headcount. Using SQL Query How would you create a singledataset with a company ID, location, and headcount, but headcountis set to 0 for companies absent from the Company Headcounttable?
Assume for now that each company ID shows up in bothtables. What tools would you use?
Depending on the tool, what function/syntax/query would you use?Suppose Company Locations has company IDs that don’t appear inCompany Headcount. Using SQL Query How would you create a singledataset with a company ID, location, and headcount, but headcountis set to 0 for companies absent from the Company Headcounttable?