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 help - If value is in table, do this

Received Response
11
Views
3
Comments

Hey. Anyone know whether theres any kind of RPL if statement on whether a data source value exists in another data sources column?

Scenario

I’ve got a dynamic variable called REF with the value of ABC123 and my customers email address is test@test.com

I have a supplemental table in my data sources that looks like so

EMAIL                BKGREF

test@test.com   ABC1

test@test.com   ABC12

test@test.com   ABC123

I want to try and say if 'REF' is in that BKGREF column, do this, else do that.

Referencing that column via ${sourcename.BKGREF} only considers the first row, whereas I need to try to reference the whole column

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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