select a row then reselect Scriptiing
In this sample table, I am trying to select the row that has a value of 2 in :Number, grab the value "A" from :Letter, then select all the rows contains "A" in :Letter. I wrote this script but it is not working. dt= current datatable();
dt <<select where (:"Number" == 2);
s=Column(dt, "Letter")<<get Values;
show (s);
dt<<select where(contains(s,:"Letter"));
looking at the log s = {"A", "A", "A",...