Sales record & Product price list

Question

Hi -
I'd like to run datasetA (sales records with various parameters including but not limited to color, quantity, size, express shipping, etc.) against datasetB (company product price list compiled according to the above-mentioned parameters and marked with Black suit, 2 pieces, L size, and Yes for express shipping) from left to right, and kind of like the Plinko simulation (however based on the state of the parameters including color, quantity, size, express shipping, rather than based on probability) from top to bottom of the company product price list.

The expected result should be
sale 001: black suit + 2 pieces + L size + normal shipping = combo A, price * quantity = total price
sale 002: white suit + 3 pieces + M size + express shipping = combo B, price * quantity = total price
sale 003: blue suit + 2 pieces + S size + express shipping = combo C, price * quantity = total price

What Alteryx formulas/tools could I use to establish the workflow?

OTrieger · Answer

@tsao88

I guess the real question will be, based on your Alteryx knowledge what will you do? Which tools will you use to get there.

The idea here is to assist you getting it solved not do to the work for you. I keep see that malady of people posting created workflows while they do not know if you did anything to try to solve your issue. Solving other people problem is wrong, as it leads to laziness and to a set of mind that the minute that someone facing an issue he or she run to post it with the hope that someone else will solve it for him, thus killing the real development of the person that on automatic basis will ask help each time that he will face some difficulties. A real Pro will try and find millions ways how to do it, he will not know everything and might need some assistance however he will have in place some thing in progress.

Being a Pro is a hard work as it demands to be able to solve problems, and they manage to figure out ways to get there by learning.

Always ask yourself what I can do about it! That will bring you one step closer to the resolution.

CoG · Answer

I made one adjustment to Dataset B (creating separate records for each unique state). Here is a workflow that Joins the Price Catalog to Order Table (and then appends default pricing info for all un-joined records):

Sample Workflow.yxmd

tsao88 · Answer

Dataset A -Sales Records     Sales TodayOrdered by Customer IDColorSizeExpress ShippingQuantity 1111BrownLY1 2222BlackXLN2 3333BlueMY2 4444BlackMN1 5555WhiteSY1 6666BrownLN3 7777BlueLY1 8888BlueXXLN2 9999BlackMY1 101010PurpleSN6        Dataset B - Company Price List     Product IDSuit ColorSizeExpress ShippingComboPrice per itemMax price if buying 6 or more100BrownLY or NA29.99N/A200BlackXLY or NB35.99N/A300BlueXXLNC46.58N/A400WhiteMND52.36N/A500Any other colorAny sizeY or NE49.99250.00       Desired Results from Alteryx     Sales TodayOrdered by Customer IDComboPriceSubtotalGrand Total 1111A29.9929.9929.99 2222B35.9971.9871.98 3333E49.9999.98199.96 4444E49.9949.9949.99 5555E49.9949.9949.99 6666A29.9989.9789.97 7777E49.9949.9949.99 8888C46.5893.16186.32 9999E49.9949.9949.99 101010E49.99299.94250.00