Hi all,
I need to open data tables where the file names are being extracted from my main table and after opening the data table, it will merge it into one data table. Also, col2 have the same values inside dt.
It should look like this:
C:\Desktop\Name_Ana_Gender_Female.jmp
C:\Desktop\Name_Grace_Gender_Female.jmp
I have this code but it only opens one data table
dt = Data Table( "sample_table" );
col_name=associative array(column(dt, "name" ) <<get values) <<get keys;
col_gender=associative array(column(dt, "gender" ) <<get values) <<get keys;
file_list = N Items( col_name );
file_path = "C:\Desktop";
For( i = 1, i < file_list, i++,
dt1 = Open( file_path || "Name_" || char(col_name[i]) || " _Gender_" || char(col_gender[1]) || ".jmp",
//merge the two opened table
)
);