How to merge two filtered arrays based on a common identifier

(0) Share

Report

Posted on by Community Power Pla...

Hello All,

I have two filtered arrays below, data into each is coming from dynamics finance and ops app's respective tables.

-Array1 (data from table 1)
1. PurchaseOrderNumber

2. ProjectStatus

3. Approval Status

........... and many other fields.

Array-2 (data from table 2)

1. PurchaseOrderNumber

2. OrdererVendorAccountNumber

3. Tax Id

4. Fixed Asset Number and......................... plenty of other fields. See screenshot of the flow below.

What I need to do is, since PurchaseOrderNumber is a common identifier between both arrays, I just need to pull OrdererVendorAccountNumber field from array-2 into array-1 , none of the other fields matter from array2 except OrdererVendorAccountNumber to be pulled into array-1. May be a merge operation but how? Please help with a solution.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

ScottShearer 25,277 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@Anonymous

Try this:

Create a new Array variable

Loop through Array 1

Inside the loop, filter Array 2 on the Purchase Order number of the current item

Add an element to the Array variable containing all data required from Array 1 and Array 2

Let me know if you need additional help.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

thank you so much @ScottShearer for sharing these steps. I understood all first three steps in place but I am not understanding the 4th step you mentioned of adding an element to the array var, do you mind sharing little more info on that or a screenshot, thanks again.

Was this reply helpful? Yes No