Merging two tables or collections into one

[asifkhawaja]

I am stuck with a very basic problem. I have two collections

Collection1

Name

------

name1

name1

Collection2

Email

------

email1

email2

I want to merge these two into one collection as following:

Collection3

Name      Email

-------------------

name 1    email1

name2     email2

Any ideas? Thanks in advance.

[CNT · Accepted solution]

@asifkhawaja Try this,

ClearCollect(colName, {Name:"Tom"}, {Name:"Mark"}, {Name:"John"});
ClearCollect(colEmail, {Email:"emailTom"}, {Email:"emailMark"}, {Email:"emailJohn"});
ClearCollect(colCombinedNameEmail, ForAll(Sequence(CountRows(colName)), ({Name:First(LastN(colName,ThisRecord.Value)).Name, Email:First(LastN(colEmail,ThisRecord.Value)).Email})))

[asifkhawaja]

Of course, of course! Thank you so much. You made my day!

[CNT]

@asifkhawaja Glad to help!