Column replacement based on information on other column

[fmarin00]

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 solution]

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])

[fmarin00]

Thanks for the suggestion. I also replaced BOT by CS in the sales unit column of the sales table using a similar formula