Join
Join is an essential Flatmap Directive that connects two data sources that share a common Key.
A Join directive is defined by creating a path in a Filesystem Recipe named: “Join ((Namespace)) ((KeyFeature))”
Extended capabilities may be enabled by adding more to the Join path name, for example:
- JoinMany ((Namespace)) ((KeyFeature))
- Join ((Namespace)) ((KeyFeature)) to ((LeftNamespace)) ((LeftFeature))
- Join ((Namespace)) ((KeyFeature)) to ((LeftNamespace)) ((LeftFeature)) GroupBy ((RightFeature))
Inside of a Join path, many other instructions are supported such as Attach, Read Settings, AddColumn, Add
Instructions inside of a Join path enable the Chef to copy in the source data files, such as Excel and CSV files, add features/columns, perform calculations, define filters, and much more.
Join Directives require a precedent Identity directive.
Join Directives may have a precendent Combine directive.