community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Column replacement based on information on other column

Meteoroid

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

alteryx1.jpg

The sales table looks like this

Alteryx2.jpg

the product master table looks like this

Alteryx3.jpg

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

 

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

 

Best regards

 

Francisco                                                 

 

                       

 

Bolide

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

Meteoroid

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

Labels