Column replacement based on information on other column

Question

Hi all

I'm a beginner Alteryx user and I got most of my workflow going but I'm having trouble trying to convert a column into the basic unit of measure for our sales.

I need to replace the values in our sales table based on a characteristic of our Product master table.

So I have a work flow that looks like this

The sales table looks like this

the product master table looks like this

After referencing the product table, I need to record my sales in cases only so the sales table will look like this at the end

I appreciate in advance any suggestions that I can get on this.

Best regards

Francisco

JoBen · Accepted Answer

Hi @fmarin00, you could just write a simple formula after your join of the two tables that says something like IIf([SaleUnit]="BOT", [SaleQty]/[Bpecase],[SaleQty])