Problem Statement

Define two associative arrays, where one represents the following "base" data: And the other represents "update" data: Merge these into a new associative array that contains every key found in either of the source ones. Each key should map to the value in the second (update) table if that exists, or else to the value in the first (base) table. If possible, do this in a way that does not mutate the original two associative arrays. Obviously this should be done in a way that would work for any data, not just the specific data given here, but in this example the result should be:

Let's start with the solution:

DECLARE base$, update$, merge$ ASSOC STRING

base$("name") = "Rocket Skates"
base$("price") = "12.75"
base$("color") = "yellow"

PRINT "Base array"
FOR x$ IN OBTAIN$(base$)
    PRINT x$, " : ", base$(x$)
NEXT

update$("price") = "15.25"
update$("color") = "red"
update$("year") = "1974"

PRINT NL$, "Update array"
FOR x$ IN OBTAIN$(update$)
    PRINT x$, " : ", update$(x$)
NEXT

merge$() = base$()
merge$() = update$()

PRINT NL$, "Merged array"
FOR x$ IN OBTAIN$(merge$)
    PRINT x$, " : ", merge$(x$)
NEXT