Grooper 2.90.0063 is available as of 3-24-2021! Check the  Downloads Discussion  for the release notes and to get the latest version.
Grooper 22.00.0005 is available as of 5-6-2022! Check the  Beta Discussion  for the release notes and to get the latest version.
Grooper 21.00.0046 is available as of 5-16-2022! Check the  Downloads Discussion  for the release notes and to get the latest version.

Combine Two Field + Compare to Lexicon

This is probably a lot easier than I'm making it.

I have two data fields that pull in content from an invoice: Routing Number and Account Number
I was provided a list where the Routing Number and Account Number are combined.
Ex:
Routing Number: 12345
Account Number: 9876
Shown on List: 1234569876

I'm trying to make sure the routing number and account number pulled from the invoice during data extraction match a line item on the list provided.

What I have done:
I put the contents of the list into a lexicon.

Question:
How do I combine two fields then compare it to the lexicon, showing if it matched TRUE/FALSE?

I thought I could use a calculate expression on a new field - combining the two data fields, then use a validate expression to validate it off the lexicon. However, that's where I'm stuck. I don't know how to write a validate expression to access the lexicon. Is that possible?

Answers

Sign In or Register to comment.