assign price to the internet sales records

[tsao88]

the goal is to assign combo price (listed in dataset001) to each of the internet sales record in dataset002

the workflow should verify whether the 4 conditions are fully satisfied based on the conditions established on the combo price list, if all 4 conditions are met, then assign a price to the internet sales record accordingly. If not, output "no combo price available"

PS -  I plan to join the 2 sets of data by column A, and if the cell is empty, no restrictions, could be any value or integer

thanks!

[Bren_Spill2]

@tsao88 - use a join tool and join both datasets on all 4 conditions to tag the price to internet sales. Then union back any records on the internet sales side that don't join. Finally use a formula to tag the any null prices with "no combo price available"

[tsao88]

@Bren_Spill2 can you kindly upload the yxmc file for this sample use case? thanks

[Bren_Spill2]

@tsao88 - which step are you having trouble with?

[tsao88]

the union tool and the formula

@Bren_Spill2 

[Bren_Spill2 · Accepted solution]

@tsao88 - the union tool shouldn't required any configuration. Just connect the J and R (assuming R contains the internet sales that didn't match). Se it to Auto Config by Name

For the formula: if isnull([Price]) then "no combo price available" else [Price] endif...  You'll need to make sure the price field is string before adding the formula