Split single row in to multiple rows - is there a limitation, how many rows can be split?

 Dear Rajdev,


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!

Best regards




Plain text icon multi_value_row_split.txt773 bytes

(2) Answers