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?