merging files, v lookup for multiple fields

[kellydzu]

hi! i’m new to alteryx so any help is appreciated!

i’m trying to join two files by matching emails so i can have a list which i includes all info based on orders.  

The order file is very large and and lists out ALL orders and their status.

The customer file is of a selected group so ideally i would like to match the emails from this file to whatever order aligns with it on the order file. 

As a result i’d like to have all the costumer information from the customer file along with the orders stacked so i can track their status.

what’s the best way to go about this? 

 

[MilindG]

See if this works.