IRI Blog Articles

Diving Deeper into Data Management

 

 

Post image for 🎥 Performing a Left Outer Join Where All Matched Records Are Removed Demonstration

🎥 Performing a Left Outer Join Where All Matched Records Are Removed Demonstration

by Susan Gegner

This demonstration shows how to create a left outer join where the match is based on one field and we use the ONLY parameter to discard matches. This join job is performed in CoSort using IRI Workbench. The join is accomplished using the SortCL tool in CoSort. IRI Workbench is used to create the job script using the SortCL language, and then it runs the job script.

Print Friendly

{ 0 comments… add one now }

Leave a Comment

Previous post:

Next post: