Solved
Merging two arrays
Hi there,
I have 2 arrays that I need to merge; I have used Merge in Join Snap but they are not coming in as Output below. seems simple but missing something.
Any guidance?
Thanks
Manohar
I...
Forum Discussion
Sure, here is a simplified version:
Input:
[{
“invoiceNum”: “12345”,
“total”: 100,
“lines”: [{
“qty”: 1,
“unit”: 50,
“extended”: 50
},
{
“qty”: 2,
“unit”: 25,
“extended”: 50
}],
},
{
“invoiceNum”: “12346”,
“total”: 150.56,
“lines”: [{
“qty”: 1,
“unit”: 50.56,
“extended”: 50.56
},
{
“qty”: 1,
“unit”: 50,
“extended”: 50
},
{
“qty”: 2,
“unit”: 25,
“extended”: 50
}],
}]
Output:
[{
“invoiceNum”: “12345”,
“total”: 100,
“lines”: [{
“lineNumber”: 1,
“qty”: 1,
“unit”: 50,
“extended”: 50
},
{
“lineNumber”: 2,
“qty”: 2,
“unit”: 25,
“extended”: 50
}],
},
{
“invoiceNum”: “12346”,
“total”: 150.56,
“lines”: [{
“lineNumber”: 1,
“qty”: 1,
“unit”: 50.56,
“extended”: 50.56
},
{
“lineNumber”: 2,
“qty”: 1,
“unit”: 50,
“extended”: 50
},
{
“lineNumber”: 3,
“qty”: 2,
“unit”: 25,
“extended”: 50
}],
}]
