Merging collections with different number of rows

[asehrawat]

Hi Everyone,

I have this requirement where I need to merge two collections. One is having 2 Columns and 5 rows and second one is having 1 Column and 2 rows. When I am merging these two collections, I am getting a collection with 3 Columns and only 2 rows (number of rows in second collection).

Is there any way by which I can Merge two collections with different number of rows, and obtain a collection with larger number of rows of the two collection?

Thanks and Regards,
Arjun Sehrawat

 

[VJR]

Hi asehrawat,

When the diagram is run as per your inputs above, the final merged collection shows up correctly with 5 rows. Refer the count of input and output collection rows below.
View attachment 1532600660743.png

It looks like you are giving parameters as Collection 2 and Collection 1 instead as 1 first and then 2 as below.
View attachment 1532600722925.png

 

[asehrawat]

Thanks for the reply. Worked for me.