You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

RPL <#data> value comparison

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!