I am using the "Molecular Similarity (Tanimoto etc)" component. This component adds two properties to its output. The "ClosestNames" and the "ClosestSimilarities" properties are multivalued. They contain multiple values delimited by semicolon (";") characters. I would like to transform this output so that each value pair from these two properties is given its own record. For example:
| ClosestNames | ClosestSimilarities |
|---|---|
| 34;56 | 0.85;0.98 |
| 13;23;45 | 0.80;0.95;0.91 |
transformed to:
| Identifier | Similarity |
|---|---|
| 34 | 0.85 |
| 56 | 0.98 |
| 13 | 0.80 |
| 23 | 0.95 |
| 45 | 0.91 |
What would be the most efficient way to perform this operation in Pipeline Pilot?
