You’re offline. This is a read only version of the page.
I have the flow which getting two set of data from two table and I want to merge two into a single array. Both of them have one common primary key which is Item Type.
For left hand side, I get all row which Item Type equal to Book, it will return all Book data, same goes to right hand side.
I want combine both array into single array for each row return from both table, I tried union but it seem not working in my case.
Any solution on my problem here? Any help will be great.
Hi,
I had two tables to join in one of my flows too and I used the "union" function to join my two tables.
I don't know if this is what you were looking for.
I had a similar issue and had to use "select" connector for each table to map keys then I could union the outputs from the "select" connectors in "compose" connector.
@NeohLooi I found a similar thread here :
--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
#1
ankit_singhal
7
Super User 2025 Season 1
#2
Michael E. Gernaey
6
Super User 2025 Season 1
#3
David_MA
4
Super User 2025 Season 1
Share
Report
All responses (
Answers (
