You’re offline. This is a read only version of the page.
55
Hi All,
I have to join two collections and display the both tables data in combobox items where size equals to "M"
Below are the collections. But Source tables are schematically not having identical columns.
ClearCollect(colTable1,
ShowColumns(Filter(Table1,Size="M"),"FirstName","LastName","size"));
ClearCollect(colTable2,
ShowColumns(Filter(Table2, Size ="M"),"FName","LName","size"));
can someone help me on this.
Share
Report
All responses (
Answers (
ClearCollect(
colTable1,
RenameColumns(
ShowColumns(
Filter(
Table1,Size="M"
), FirstName","LastName","size"
),"FirstName","FName","LastName","Lname"
)
);
ClearCollect(
colTable2, ShowColumns(
Filter(
Table2, Size ="M"
),"FName","LName","size"
)
);
ClearCollect(
colAll, colTable1, ColTable2
)
Use Sort(colAll, Lname, Ascending) as the Items property of your control. FYI, my formula is not an inner join, just an append of Table2 to Table1 after reshaping Table1. It does not account for duplicates in the final collection.
