Jump to content

List to List Comparison


Squeaky Data
 Share

This topic is 4336 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I am not sure what to call this kind of comparison so I have had a hard time searching for any information.

I have two list that are used to manage record access security. One list is generated for extended privileges and the other is from field data.

List One:

London

New York

List Two:

New York

Toronto

London

I am trying to figure out a boolean calculation to see if ANY of the values in list one match ANY of the values in list two. Pattern count will only work if the lists are in the correct order so I think I need to figure out a recursive calculation to compare each value individually from list one against list two.

Link to comment
Share on other sites

This topic is 4336 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.