Merge Byline Proof with airSlate SignNow

Merge byline confirmation

now that we have that location table we want to create a new and improved sales fact table so let's begin by clicking transform data to bring us back to the power query editor and we're going to do this by using merge queries a brilliant feature of power query and on the sales prep table up in the Home tab merge queries is on the end and I want to click the drop down arrow so that I can specify to merge queries as a new query I don't want to affect the current sales prep query because my location query is referencing it from the previous lesson I want a new query which will be our sales fact query now in the merge window I have the sales prep table selected because I began the merge query from it but then I have this drop-down list where I can specify the location table so what I want to do here is bring in the location ID from the location query or table so that in the sales table I can remove the location column and also the country column and the location ID will be used to reference that data so in the first query I'm going to select the location column and then in the second one select the location column because at the moment that is being used to join or to identify the data in the tables and a bottom of the window is just estimating my matches and has confirmed that we have a complete match now there are different join coins available in here which is not something we're going to get into detail with now that information will be provided by a more in depth power query course but this is a very powerful feature with six different drink lines for us right now the left outer join is what we need so if I click OK that will perform the merge and bring the location table into this new query now with this table in the header there is a button to expand the table data so if I click on that button it will ask me what fields from that table would you like now we just want location ID so I'm removing location removing country code and also removing the original column name as a prefix if I click OK the location ID is brought into this table here it is so I'm going to click and drag that column into position and then I can select the location column hold control and select the country code column right click and remove them because now I have that index their ID I can use that to reference the data in the other tables I don't need them in this big over 1 million row fat table this is good practice keeps our model small and also efficient in respect of our speed of calculations and now want to repeat...