Split single row in to multiple rows - is there a limitation, how many rows can be split?
I have tested your script from yor feedback on Question "How to split single row in to multiple rows in the same column in Spotfire" (https://community.tibco.com/questions/how-split-single-row-multiple-rows...) and it works nicely with a few rows. When the number of rows (from which some have multiple values, which needs to be split) is going beyond approx 100 (in my case >103 rows), then I get an R-errormessage from Spotfire:
TIBCO Enterprise Runtime for R returned an error in '[<-.data.frame'('*tmp*, i, value=list("PartNumber" = : missing value where TRUE/FALSE needed'.
Unfortunately my source datafile is around 150.000 rows, so if there is a limit, this idea will not work for me.
Thanks a lot for your feedback!