topic Re: select a row then reselect Scriptiing in Discussions

select a row then reselect Scriptiing

GroupSquareWolf — Fri, 09 Jun 2023 17:08:00 GMT

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", "B", "B", "B"};

And no rows were selected at the end of the script.

What went wrong?

Thanks

Re: select a row then reselect Scriptiing

jthi — Thu, 18 Aug 2022 17:25:03 GMT

I think you should have all rows selected based on your script because s contains all values from Letter column, not just those which match number 2's letter and then you check if current rows letter is in that list (it always is).

There are many ways to do what you want. Here is the method I would most likely use ( :(

Names Default To Here(1);
dt = New Table("Untitled",
	Add Rows(6),
	New Column("Letter", Character, "Nominal", Set Values({"A", "A", "A", "B", "B", "B"})),
	New Column("Number", Numeric, "Continuous", Format("Best", 12), Set Values([1, 2, 3, 4, 5, 6]))
);

num_rows = dt << Get Rows Where(:Number == 2);
show(num_rows);
letters_of_interest = dt[num_rows, "Letter"];
show(letters_of_interest);
dt << Select Where(Contains(letters_of_interest, :Letter));

You could also use << Select Where in combination with << Get Selected Rows (one example )

Re: select a row then reselect Scriptiing

GroupSquareWolf — Thu, 18 Aug 2022 17:29:24 GMT

Thank you. I certainly missed the "Get Rows part"

I came up with this script after a bit of digging

dt= current datatable();
dt <<Row Selection(select where (:"Number" == 2));

s= (dt:"Letter"[dt << get selected rows]);
show (s);

dt<<Row Selection (select where(contains(s,:"Letter")));