0 Replies Latest reply on Apr 29, 2020 1:18 PM by 3149299

    RPL <#data> value comparison

    3149299

      Hello,

       

      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>

      <#fields NAME>

      <#if TABLE1.NAME=TABLE1.NAME>YES<#else>NO</#if>

      </#data>

       

      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.