Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

List to List Comparison

Squeaky Data
in The Left Brain

Featured Replies

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.

Try the FilterValues() function.

  • Author

Try the FilterValues() function.

Thanks, I just started to explore that and it looks like it should work.

Do you know if this type of match has a name?

http://en.wikipedia.org/wiki/Intersection_%28set_theory%29

Create an account or sign in to comment

https://fmforums.com/topic/77204-list-to-list-comparison/
Go to topic listing

Important Information

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

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.