It looks as if your store order ID isn't unique, so you'll need to either bring in a unique identifier (which will give it a one to one match) or use other fields in additional to the store order ID in order to make the join unique.
I have found a field called Line Item Name which may work:
To add some more context, the "store order id" is unique. The "store order id" is on two rows because if the order has two skus, one sku is on one row and the second sku is on the second row, with the "store order id" being repeated for each sku. This is what is causing some problems for me.
I am also seeing the same thing occur when from my 3PL. The "store order id" is on three or more rows since there can be three objects with that order, ie the main product, the box for the product, a sticker and a marketing insert.
I have read through some guides and it appears I have a many-to-many relationship and perhaps I need to do data blending but I am not currently familiar with that method. Hoping for some guidance on this forum.
Thanks for any suggestions and help.
Just fyi on the topic of Tableau Prep there is a Dev Office Hours session tomorrow that may be of interest. It's on Tableau Prep Conductor, further details including the registration link available below by Amanda Boyle
Hope this helps,
[Program Manager - Tableau Community]