2 input data, bringing in a column based off a common value

JSheppard98

Hi there,

I have 2 files as an example, both of which actually have around 100-200 rows. I am struggling to input these 2 files as raw input data and then I essentially want to vlookup in the "daily balances example" file (in a new column with the previous date), to the "prev day balances example" file on "account number", and pull through the balance/amount. 

I can obviously manually do this in excel with both files open and vlookup fine, but wondering if Alteryx can automatically do this for me and produce an output file of the daily balances example with this data populated?

Let me know if you need any more clarification? 

Thank you

Daily Balances example.xlsx

prev day balances example.csv

Felipe_Ribeir0

Hi @JSheppard98 

Now i understood, you want the AMOUNT column from the prev day balances example.csv to populate this column, right? Here it is:

2 input data, bringing in a column based off a common value.yxzp