You’re offline. This is a read only version of the page.
Announcements
44
how do you create a table that outer joins?
Table 1
Department Name Facility Name
Dept 2 North
Table 2
Department Name Facility Name
Dept 1 Blank
Dept 2 Blank
Result Table
Department Name Facility Name
Dept 1 Blank
Dept 2 North
Not in the conventional sense. There are no keywords etc to do that.
If you did a ClearCollect(Collection1, Collection2). You end up with a merge/append, where all the new fields in Collection 2, get added to the Collection1 columns and are NULL. All the Collection2 columns that match Collection1 in name and *type, just are there, and any Collumns in Collection 2 that were not in Collection one are simply merged in with their values.
You would have to do some definite work (addColumns, ifs compares blah blah ) to do what you are asking.
Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
Share
Report
All responses (
Answers (
