Merging two JSON arrays of the same size

(0) Share

Report

Posted on by dignus93reply

Hello folks I have two json array of the same size.

ARRAY1:

[
{
"Column1": "Main directory1",
"Column2": "Sub directory1"
},

{
"Column1": "Main directory2",
"Column2": "Sub directory2"
},

{
"Column1": "Main directory3",
"Column2": "Sub directory3"
}
]

ARRAY2:

[
{
"Column3": "urlNum1"
},

{
"Column3":"UrlNum2"
},

{
"Column3":"UrlNum3"
}
]

I would like to have output like this:

[
{
"Column1": "Main directory1",
"Column2": "Sub directory1",
"Column3": "urlNum1"
},

{
"Column1": "Main directory2",
"Column2": "Sub directory2",
"Column3":"UrlNum2"
},

{
"Column1": "Main directory3",
"Column2": "Sub directory3",
"Column3":"UrlNum3"
}
]

I am trying with Apply to each or Do Until or Append to variable but I am struggling a lot. Can you help me?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

CU-18081211-6 9,270 Moderator on at

Like (0)

Report

Hi @dignus93reply ,

Here is my thoughts. To save some space please follow the number:

a) Let's initialize some stuff:

1.

2.

3.

4.

b) And now, here is the magic 😊 ...

Hope it helps !

Was this reply helpful? Yes No
dignus93reply 87 on at

Like (0)

Report

Thanks a lot @gabibalaban this works good in this case.

Now let's level up. What if I have the same ARRAY1 as before
ARRAY1:
[
{
"Column1": "Main directory1",
"Column2": "Sub directory1"
},
{
"Column1": "Main directory2",
"Column2": "Sub directory2"
},
{
"Column1": "Main directory3",
"Column2": "Sub directory3"
}
]

but the ARRAY2 now has more key-values for each record. The length it's still the same of the other
ARRAY2:
[
{
"Column3": "urlNum1",
"Column4": "prop1",
"Column5": "asd1"
},
{
"Column3":"UrlNum2",
"Column4": "prop2",
"Column5": "asd2"
},
{
"Column3":"UrlNum3",
"Column4": "prop3",
"Column5": "asd3"
}
]

my desired output follow the same patter as before
ARRAYOUTPUT:
[
{
"Column1": "Main directory1",
"Column2": "Sub directory1",
"Column3": "urlNum1",
"Column4": "prop1",
"Column5": "asd1"
},
{
"Column1": "Main directory2",
"Column2": "Sub directory2"
"Column3":"UrlNum2",
"Column4": "prop2",
"Column5": "asd2"
},
{
"Column1": "Main directory3",
"Column2": "Sub directory3",
"Column3":"UrlNum3",
"Column4": "prop3",
"Column5": "asd3"
}
]

I guess I can follow your pattern and do this reading the key value manually. But is there a way to loop through ARRAY1 and ARRAY2 in order to have a ARRAYOUTPUT???
Regards,
Alessandro

Was this reply helpful? Yes No