Hi @Natalie_Burns - A flow like this can accomplish what you’re trying to do:
Pull from Shopify step, I’m pulling in my
Line Item details.
Then, I used the
Combine Column step to create a new column called “Customer Name”. Since Shopify uses two separate columns,
Order: Customer: First Name and
Order: Customer: Last Name, I decided that I preferred if First and Last Name was combined into a single column. (This step is totally optional and up to you!) If you’d like to do this too, make sure to click into
Advanced Settings and put in a space in the
Delimiter field. This will make sure there’s a space in between the first and last names.
Then, I use the
Merge Values step and configured it like so:
You’ll see that in my example, I’m creating a unique row for each
Order: Id and
Customer Name. You can add more columns below, “Create a row for each unique value in…” based on the columns you want to be able to see in your output.
Of course, if you don’t get about the unique orders, but just a list of line items ordered by a particular customer, I recommend using
Order: Customer: Id and
Customer Name columns instead.
Let me know if you need any other help with this one!