When your day-to-day work includes plenty of document editing, you already know that every file format requires its own approach and in some cases specific applications. Handling a seemingly simple spreadsheet file can sometimes grind the whole process to a halt, especially if you are attempting to edit with insufficient software. To avoid this sort of problems, find an editor that will cover all your needs regardless of the file extension and join secret in spreadsheet without roadblocks.
With DocHub, you are going to work with an editing multitool for virtually any occasion or file type. Minimize the time you used to devote to navigating your old software’s features and learn from our intuitive user interface while you do the work. DocHub is a streamlined online editing platform that handles all of your file processing needs for virtually any file, including spreadsheet. Open it and go straight to efficiency; no previous training or reading instructions is needed to reap the benefits DocHub brings to document management processing. Start by taking a few minutes to create your account now.
See upgrades within your document processing just after you open your DocHub profile. Save time on editing with our single solution that can help you become more efficient with any document format with which you need to work.
[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