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!
