I am new to using the <#data> RPL tag.
What I am trying to do is to compare values stored within a variable and then made a decision off the back of the result.
An example would be:
<#data TABLE1 as TABLE limit=1000000>
<#filter TABLE1.RIID_ = TABLE2.RIID_1>
If a person had 2 names in the table that match, I would want it to display Yes, if they do not then No.
Is this possible at all?
At the moment despite the names being different, I get YES for both.