We have a JSON object which looks like:
{"data":[[0,"data1","0.989",1,"DB_1"],[1,"data2","0.966",2,"DB_1"],[2,"data3","0.951",3,"DB_1"],[3,"data4","0.942",4,"DB_1"],[4,"data5","0.935",5,"DB_1"],[5,"data6","0.925",6,"DB_1"],[6,"data7","0.922",7,"DB_1"],[7,"data8","0.915",8,"DB_1"],[8,"data9","0.905",9,"DB_1"],[9,"data10","0.902",10,"DB_1"]]}
I attached the zipped protocol, how we are trying to read it. If I read it in with the solution of first two cases, it only works, if the array of arrays contain more than one row. It seems to me that this is a Pipeline Pilot bug, since I see no reason why it should read differently if the first dimension of the array is 1 and >1.
We also tried to read it with option Convert Arrays-of-Arrays, which reads it properly, however, when we want to Unmerge it, it completely unmerges it to elements, not in two stages (unmerge based on dimension 1, so that we get rows/records of arrays). The same thing happens if I recreate the whole Array of Arrays with Pipeline Pilot (using FOR cycles - this I did not put into the protocol).
