condition of IF is based on the input table

[fullmoon558]

Hi,

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

Name	Age
Josh	21
Alex	67
Andy	46
Rob	32

The table 2 is:

Age	Type1
<30	y
>=30 <60	m
>=60	o

The table 3 is:

Age	Type2
= 21	new
< > 21	not new

I want to get the following table:

Name	Age	Type1	Type2
Josh	21	y	new
Alex	67	o	not new
Andy	46	m	not new
Rob	32	m	not 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,

Age	Type2
< = 32	new
> 32	not new

the final table should be 

Name	Age	Type1	Type2
Josh	21	y	new
Alex	67	o	not new
Andy	46	m	not new
Rob	32	m	new

[terry10]

@fullmoon558 

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

[binuacs]

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

[fullmoon558]

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

[geraldo]

@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:

Age	Type1
< 30	y
< 60	m
>= 60	o

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

Here's an example workflow