I am comparing two spreadsheets. I need to compare changes in location between people.
Each individual on the spreadsheets has a unique identifier.
I have loaded each into an excel reader. I then used a joiner node to join sheets.
I used the unique identifier as the join key. Top input left table = unique identifier. Top input right table = unique identifier.
Matched rows to create inner join.
Output options = spilt join result.
I am trying to use the rule engine node to create a rule that creates a new column based on checking differences between a change in job location. I would like a new column to be created confirming a true or false value.
That way I can confirm the change in location if there is one for each person.
Can anyone please help with the syntax ?
So far I have : $Job Location$ MATCHES $Job Location$ => FALSE .
However it’s not showing the correct results as I know already which people have changed location.
I just need the formula to work.