Announcements
I am stuck with a very basic problem. I have two collections
Collection1
Name
------
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.
@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})))
Of course, of course! Thank you so much. You made my day!
@asifkhawaja Glad to help!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 483
WarrenBelz 399 Most Valuable Professional
11manish 327
