topic Re: Which table does For Each Row() apply to? in Discussions

Which table does For Each Row() apply to?

nikles — Thu, 14 Feb 2019 17:21:50 GMT

When using the FOR EACH ROW() command to step through each row in a table, does JMP just assume the Current Data Table?

I've made a habit of issuing a Current Data Table("target_table") command prior to using the For Each Row(), just in case. I'm now wondering if this is necessary?

Re: Which table does For Each Row() apply to?

Jeff_Perkinson — Thu, 14 Feb 2019 18:04:26 GMT

Yes, For Each Row() assumes the current data table. As such it can be ambiguous and can rely on a Current Data Table() call just before it.

A few releases ago we improved the syntax of For Each Row() and it now takes an argument in the first position to specify which data table to use. That's the best practice to ensure it's working on the data table you intend.

Re: Which table does For Each Row() apply to?

nikles — Fri, 15 Feb 2019 00:55:44 GMT

That's great! thanks.