Import Multiple CSV Files from different folder, Update Value, and save CSV with different names
I have about 95 csv files with different column names saved under main data folder and 95 different sub-folders like \data\dataset1\dataset1.csv, \data\dataset2\dataset2.csv, etc. id1 and id2 columns are common variables across all files. I want to to do the following:Import all 95 csv files to JMP (using JMP Pro 16)Update a value based on a condition across all 95 files: if (id1 = 'a001' then id2...