If you edit documents in various formats daily, the universality of your document tools matters a lot. If your tools work with only some of the popular formats, you may find yourself switching between software windows to join fee in spreadsheet and handle other file formats. If you want to eliminate the hassle of document editing, get a solution that can effortlessly handle any extension.
With DocHub, you do not need to focus on anything short of the actual document editing. You will not have to juggle programs to work with different formats. It will help you edit your spreadsheet as effortlessly as any other extension. Create spreadsheet documents, edit, and share them in a single online editing solution that saves you time and boosts your efficiency. All you need to do is register an account at DocHub, which takes just a few minutes.
You will not need to become an editing multitasker with DocHub. Its functionality is sufficient for fast papers editing, regardless of the format you want to revise. Start by creating an account and see how straightforward document management can be having a tool designed particularly to meet your needs.
[Music] in this video were going to create a query in google sheets that allows you to join two different tables together in one single query output so you can see here i have a data set of orders on the tab were on now i have a column for product id quantity and order date on my first tab i have another table it also has the product id number the product name and the cost so the first thing you need to do is identify your lookup value the value or column the column that contains the values that link the two tables together in this case it is the product id both tables have a product id so the next thing you want to identify is what is your lookup table and what is your raw data in this case my lookup table is the product id table it has unique values for the product id number that define what that product id means this orders tab is my raw data it has multiples of the same for product id so were going to begin our query statement and we want to begin with an opening curly bracket