topic Re: Get Rows() not working in Discussions

Get Rows() not working

mostarr — Fri, 09 Jun 2023 19:50:14 GMT

I have

row_nums = data << Get Rows Where( num(data:"Donor") == i & data:"A or B" == "A");
d_A_rows = data << Get Rows(row_nums);
Write(d_A_rows);

but it writes the row numbers still instead of the actual row content. Am I missing something?

Re: Get Rows() not working

brady_brady — Fri, 18 Jun 2021 18:36:09 GMT

Hi,

You can do this:

row_nums = data << Get Rows Where( Num( data:"Donor" ) == i & data:"A or B" == "A" );

Write( data[row_nums, 0] );

Once you have the row numbers you need in row_nums, you can index the table (which I presumed is named data) directly using the syntax table[row,col]. In your case, row_nums are the rows you want, and 0 means to get all columns.

Cheers,

Brady

Re: Get Rows() not working

mostarr — Fri, 18 Jun 2021 18:43:10 GMT

Thank you. That works perfectly, and is very incisive in educating me about coordinate-indexing tables as well.