I have two data streams, one containing geometry, the other containing text attributes. I’d like to merge them based on the first value in each list, which is a unique text string identifier. The two streams of data are not sorted, and either one may contain data that the other does not.
Not sure what component to use here. If this were SQL I’d be doing a full join of two tables based on a shared column.
DATA 1
{0}
[0] “9104284239LE”
[1] Polyline Curve
{1}
[0] “3473483543SK”
[1] Polyline Curve
…
DATA 2
{0}
[0] “3473483543SK”
[1] “Blue”
[2] “Circular”
[3] “30 ml”
{1}
[0] “123834042DR”
[1] “Red”
[2] “Oblong”
[3] “20 ml”
…
Desired merged:
{0}
[0] “9104284239LE”
[1] Polyline Curve
[2] null
[3] null
[4] null
{1}
[0] “3473483543SK”
[1] Polyline Curve
[2] “Blue”
[3] “Circular”
[4] “30 ml”
{2}
[0] “123834042DR”
[1] null
[2] “Red”
[3] “Oblong”
[4] “20 ml”
…