Concatenate data tables in loop only works first time
Jul 8, 2015 4:38 AM(6654 views)
I have a script where I loop through a data table with random number of rows. For each row I execute 3 sql statements to get 3 tables with data. That part of the solution works fine but subsequently I want to concatenate the 3 tables produced for each row in the original table and this is where my jmp knowledge falls short.
Instead of concenate 3 tables for each row I get a result where the 3 tables from the first row are concenated as many times as there are rows. I assume I have to do something to let jmp know that the 3 tables have changed content before doing the concatenation and have tried to do so by explictly assigning the tables produced by the 3 statements (dtSite, dtCountry, dtTrial) to new names before doing the concanation but that does not do the trick. See code below.