Discussions

RPL <#data> value comparison

User_T0ECL
User_T0ECL Posts: 20 Red Ribbon
edited Apr 29, 2020 9:18AM in Developer Tools

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.

Sign In or Register to comment.