2 Replies Latest reply: Nov 5, 2013 4:31 PM by Donald Hutchins RSS

    Lookup field value using variable (not inter-record)

      I'd appreciate ideas on a solution for how to perform a lookup of a field value in a Table, but not for an inter-record lookup (where you could use Lookup() or Exists(), but rather when the value you want to lookup is in a script variable.

       

      I am trying to load files using FOR Each File in filelist(...)  and the number of files is quite large (many 100's).  I have a table that contains files I want to exclude (table is called 'ExcludeFiles' and has a column called 'FileName').  So I would like to do this:

       

      FOR Each File in filelist('....')

         IF IsNull(Lookup( 'ExcludeFile', 'ExcludeFile', '$(File)', 'ExcludeFiles')) Then

            ... process the file

         END IF

      NEXT File

       

      However, Lookup() is not working here.  Nor could I get Exists to work.  I gather because both are intended for inter-record lookups.

       

      Any ideas on how I can look for a match in a resident table when the matchvalue is in a variable (such as $(File) in this case)?