Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

merging files, v lookup for multiple fields

kellydzu
5 - Atom

 

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? 

 

 

B12C6B6B-1A43-49CA-AC7B-F485014C0DF9.jpeg

1 REPLY 1
MilindG
12 - Quasar

See if this works.

Labels
Top Solution Authors