Hello everyone..
I have two excel files and I'm trying to do a vlookup from one excel to another using Alteryx. Basically to get this automated monthly without human intervention if possible. The data has thousands of rows, this is just a short snipit to provide the logic to the thousand of rows.
Below is how the spreedsheet looks ( keep in mind it has more columns and rows, this is just a short snip it)
Example::
"Spreadsheet1.xlsx"
| User | Computer | Status | Vlookup Computer Name |
| Bobby | Dell123 | | |
| Nomad | Hp789 | | |
| Henry | Macbookbook345 | | |
Now below is spreadsheet2, we are comparing spreadsheet 1 values to get spreedshet 1 values updated.
- On spreadsheet2 we will look to see if the "Computer" Column values from spreadsheet 1 is there
- If the "Computer" name are in spreadsheet2 then update column "Vlookup Computer Name" with the Computer name ie "Dell123" and change column status to "new"
-If "Computer" name is not in speadsheet 2 then update spreadsheet 1 "Vlookup Computer Name" to NA and status to "Closed" on spreadsheet 1
spreadsheet 2.xlsx
| Computer |
| Sonic123 |
| Hp789 |
| MacbookPro981 |
Final output: Spreadsheet 1 with the following updates( note: make the computer column to match the values from spreadsheet2 not just the computer name):
| User | Computer | Status | Vlookup Computer Name |
| Bobby | Dell123 | closed | NA |
| Nomad | Hp789 | New | Hp780 |
| Henry | Macbookbook345 | closed | NA |
