How to create formula for a column by looking values from another select tool in Alteryx

[SCR]

Hi, I am new to Alteryx.

I have a select tool which gives below output. All the values in Year column will be the same.

Table 1

ID	Loan ID	Amount	Year
1	234	1,000,000	2019
3	456	200,000	2019
4	789	275,000	2019
4	123	90,000	2019
5	567	750,000	2019

What I need, is use the value from year column which is 2019 in this example and check a similar table that has multiple values for the Year column, create anothe r column "Year to Date Ind". The values in this column will be 1 if Year = 2019 and  =0 else. 

The second table should be like below after adding the new column

Table 2

ID	Loan ID	Amount	Year	Year to date Ind
6	890	20,000	2016	0
7	654	300,000	2017	0
8	236	930,000	2020	0
9	258	1,200,000	2019	1
10	239	369,000	2019	1

Thank you in advance!

[fmvizcaino · Accepted solution]

Hi @SCR ,

I'm not sure if this is what you are looking for, but here it is.

Best,

Fernando Vizcaino

[bpatel · Accepted solution]

hi @SCR ,

you can also use the join and do a comparison. 

[SCR]

Thank you ! This seems to be very clean solution.

[SCR]

Thank you,

That is very good and I never thought about this way. Thank you again