We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

condition of IF is based on the input table

fullmoon558
6 - Meteoroid

Hi,

 

Please help me on this. I have three tables. Table 1 is:

NameAge
Josh21
Alex67
Andy46
Rob32

The table 2 is:

AgeType1
<30y
>=30 <60m
>=60o

The table 3 is:

AgeType2
= 21new
< > 21not new

 

I want to get the following table:

NameAgeType1Type2
Josh21ynew
Alex67onot new
Andy46mnot new
Rob32mnot new

 

If the conditions in table 2 and table 3 change in the future, the final table should be updated based on the new conditions automatically. For example, if the table 3 changes to the following new table 3,

AgeType2
< = 32new
> 32not new

the final table should be 

NameAgeType1Type2
Josh21ynew
Alex67onot new
Andy46mnot new
Rob32mnew
4 REPLIES 4
terry10
11 - Bolide

@fullmoon558 

 

You can accomplish this with the "Dynamic Replace" tool.  :)

binuacs
20 - Arcturus

@fullmoon558 One way of doing this with the dynamic replace tool

binuacs_0-1683757182727.png

 

fullmoon558
6 - Meteoroid

Please help me to transfer the input table 2 and 3 to the two input tables you are using.

geraldo
13 - Pulsar

@fullmoon558 

 


First you have to think about building your condition tables in the most rational way possible without gaps in the same classification
e.g >=30 <60 the new table would look like this:

AgeType1
< 30y
< 60m
>= 60o

 

 

In Alteryx you build a formula to handle the dynamic replace. So when you change the rule on the table you don't need Alteryx reserved words

geraldo_0-1683807187758.png

 

 

Here's an example workflow

Labels