Join tool - Adding product features without duplicating price level

Question

Hi all,

I was hoping for your expert advice on the below problem I am facing in Alteryx.

I have a data file 1 including several different products and their respective prices and data file 2 showing the different product features for each product. The pricing is done based on product level and therefore prices are unavailable on product feature level, and I want to assign the different features to each product.

When combining these two files via the join tool, Alteryx is adding the price in data file 1 to each of the product features (as per below example). Meaning instead of 10 Euros, the product price is 40 Euros.

Is there a way I can show all product features for each product without duplicating the product price to each of them?

Thanks a ton!!

Screenshot 2023-05-08 125107.png

LM_APAC2023 · Answer

This makes a lot of sense, thanks very much Yoshiro!

If I wanted to to add the net price as well (updated exemplary data attached), would you happen to know how I would need to tweak the multi-row formula to only show the respective price levels once per contract?

Thanks again, you are being a really big help for me on this!

Updated Examplary Data.xlsx

Yoshiro_Fujimori · Answer

Hi @LM_APAC2023 ,

As long as you join with [SKU Number], it is unavoidable to have the number of rows.

So you may want to keep the value of [Product Price] only for the 1st row of each [Contract].

You can do this with Multi-Row Formula tool.

Workflow

Multi-Row Formula: Expression

Output

Does it make sense for your case?

Join_FindReplace.yxmd

LM_APAC2023 · Answer

Thank you very much for your help, Yoshiro!

This is the updated version of the exemplary data, as I believe the previous example might have not reflected all data points - apologies for that. I am matching file 1 and 2 based on SKU number and the desired outcome would be to not duplicate the price for each of the rows under one contract, but only show the total price per contract. At the moment my joint is showing the price per contract product feature, means 30 Euros instead of the correct amount of 10 Euros.

Updated Examplary Data.xlsx