topic Re: How to check if list value exist in folder? in Discussions

How to check if list value exist in folder?

UserID16644 — Sat, 10 Jun 2023 23:50:59 GMT

Hi all,

I have files that needs to be checked if it is existing in a folder. If it does not exist, a prompt will show which file names are not in my list. Here's a snippet of my code:

//Sample Data
dt = Open( "$SAMPLE_DATA/Quality Control/Diameter.jmp" );
New Column ("Machine Op", Character,
    Formula
            ( "Machine_" || :MACHINE || " Op_" || :OPERATOR )      
        );
dt_list =associative array(column(dt, "Machine Op" ) <<get values) <<get keys;

//Files in folder
directory = "C:\Users\Desktop\Machine Operator Reference";
fileNames = Files In Directory( directory );



/* if dt_list does not exist in fileNames, prompt data table with missing file */

Re: How to check if list value exist in folder?

jthi — Wed, 13 Jul 2022 08:34:34 GMT

Check set operations for associative arrays Scripting Guide > Data Structures > Associative Arrays > Associative Arrays in Set Operations

Re: How to check if list value exist in folder?

UserID16644 — Thu, 14 Jul 2022 02:37:53 GMT

How can I transform this into an array?

fileNames = Files In Directory( directory );

Re: How to check if list value exist in folder?

txnelson — Thu, 14 Jul 2022 05:07:56 GMT

The variable fileNames, is a JMP List, which is similar to an array. Elements within the list, can be referenced by subscript;

fileNames[3] returns the 3rd file name from the list.

If you are asking, how do you move this into an Associative Array

dt_list=associative array(filenames)