SET rownum = 1
UNTIL CrimeNames[1,rownum] = ""
SET Crime = CrimeNames[2,rownum]
Create Global Data Item Crime, Sheet
SET rownum = rownum+1
The above syntax is not accepted and looking at the documentation I fear that it would just create the sheet called Crime over and over instead of a new sheet for each crime name. Is there a way to create sheets dynamically? Id rather not have to create the sheets in the information store since they change often.
Thanks for any advice.