I have two files that I download from a data warehouse. They have a column in common (Number). I am trying to automate the end result by connecting and loading files so all I have to do is download new data and open my report file to get updated results. I want to select most columns from one file, and then pull in two fields/columns from the other file based on the matching column (unique numbers).
Simplified example (there are several more columns in each of the actual files)
File one/Sheet1: Number Att1 Att2 Att3
File two/Sheet2: Number Att4 Att5
Report File: Number Att4 Att5 Att2 Att2 Att3
Is this possible to automate as described?
Thanks.
Bookmarks