You’re offline. This is a read only version of the page.
Announcements
I have two arrays with a key column, how can I join on the matching keys and bring in the columns (OBJECTS) from both arrays?
There are approximately 3,000 items in each array, so I am looking for something that won't run for 2 weeks.
Hi @Anonymous :
At present, what I can think of is to use two nested apply to each action to achieve it, but this means that this will create a loop of 3000*3000=9000000 times. The performance of this flow will be very poor, and I can’t ensure that this flow can run normally to the end, which is why I do not recommend using Flow to achieve this requirement.
I suggest you import the data into the database, and then use inner join to achieve this requirement.
Best Regards,
Bof
Share
Report
All responses (
Answers (
501
