This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I cant access your excel sheets as they are pointed to a local file on your machine. You can usually copy and paste selected records as seen in the screenshot below, and right click anywhere on the white canvas and paste, and it will create a text input tool with the data you copied.
In your case, it sounds like you want to do a left join. So you want to keep all the data on the left, and add on extra data on the right. Im not sure which of your files have more data, but it may well be a right join. I have attached your workflow which has been updated with a union tool after the join tool.