I have two tables, Table 1 and Table 2.
Table 1 pulls data from open API and creates new record, one of the columns is the Date column (e.g. 1998-05-31). Each row has different dates. One of my functions formats the Date and creates new Variable leaving only the year (1998), I used it in another column and concatenate it with other field.
The same variable I would like to use and create new rows in Table 2. However, before that I want the function to loop through the existing records in Table 2 and create new row ONLY if such year (1998) doesn't exist yet. So, basically same year in that Table would mean a duplicate.
I tried different ways but the outcomes are:
1. Rows with that Year already exist
2. Automation throws an error of finding duplicates if I use Unique condition in Table 2.
Table 1.
Table 2.
Functions:
