I try to make a legit post here, but my post is marked as spam. please make my post available in community
Link to post: (How to make subset from rows containing certain string in a specific column)
by achid03
https://community.jmp.com/t5/Discussions/How-to-make-subset-from-rows-containing-certain-string-in-a/m-p/398220#M64905
Hi All, I want to find certain rows that have string ended with "452" under column "Sample_ID". These rows will be made into a subset together with all columns from original data table. I tried to it like below, but I got this messages in log: I/O problem. Unable to open in ReadWrite mode. The system cannot find the file specified. Can anyone help me with this? thanks Names Default to Here(1); Clear Log(); Clear Symbols(); Close All( Data Tables, NoSave ); Close All(Journals, NoSave ); // pick data table 1 dt1_dir = Pick Directory( "Select directory for data table 1"); dt1_Name = Pick File( "Select data file 1", dt1_dir, {"JMP Files|jmp;jsl;jrn", "All Files|*"}, 1, 0, 0 ); Show(dt1_Name); // show dt1_Name string in log dt1=Open(dt1_Name); // reassign dt1 to data table from string dt1_Name Show(dt1); // show data table dt1 in log to check // pick data table 2 dt2_dir = Pick Directory( "Select directory for data table 2"); dt2_Name = Pick File( "Select data file 2", dt2_dir, {"JMP Files|jmp;jsl;jrn", "All Files|*"}, 1, 0, 0 ); Show(dt2_Name); dt2=Open(dt2_Name); Show(dt2); //concatenate two tables and concat_dt is the output table concat_dt = dt1 << Concatenate(dt2, Output Table("concat data table"), Create Source Column ); Show(concat_dt); //show concat_dt data table in log Close(dt1, NoSave); Close(dt2, NoSave); //close both dt1 and dt2 //select specific sample_ID from concat_dt and make subset out of it prep_dt = concat_dt << Subset(Row( concat_dt << get rows where(Regex( :Sample_ID, "71MT052800452") == :Sample_ID)), selected columns only(0), ); Close(concat_dt); // close concat_dt
This message has 0 replies
