Join tool - Adding product features without duplicating price level

[LM_APAC2023]

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!!

[Raj]

please share some sample data.

[LM_APAC2023]

Thank you for looking into this!

Adding the exemplary data set reflected on each of the tabs:

Output: Shows the output I am getting (yellow highlighted the duplicate price rows)

Sheet 1: Product and price details

Sheet 2: Product features (not priced individually)

Thanks again!

[Yoshiro_Fujimori]

Hi @LM_APAC2023 ,

I cannot recreate your issue on my Designer.

You may use Join or Find Replace tool.

Either way, there would not be duplicate records as your sample data.

Workflow

Output

Find Replace tool configuration

Join tool configuration

Could you let me know if you still have the issue?

[LM_APAC2023]

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.

[Yoshiro_Fujimori]

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?

[LM_APAC2023]

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!