I am stuck with a very basic problem. I have two collections
Collection1
Name
------
name1
name1
Collection2
------
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.
Solved! Go to 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 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!
User | Count |
---|---|
261 | |
110 | |
89 | |
53 | |
44 |