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?
In this role, we often need to combine large datasets. Suppose you’re given two datasets Company Locations, with the col
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
In this role, we often need to combine large datasets. Suppose you’re given two datasets Company Locations, with the col
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!