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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
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