Dataset Join & Merge

{'type': 'object', 'required': ['leftRows', 'rightRows'], 'properties': {'joinType': {'enum': ['left', 'inner', 'right', 'full', 'leftAnti', 'rightAnti', 'union'], 'type': 'string', 'description': 'Which rows to keep. left (default): every left row, enriched where a match exists. inner: matched rows only. right: every right row. full: everything from both sides. leftAnti: left rows with no match on the right. rightAnti: right rows with no match on the left. union: stack both lists, no key needed.'}, 'leftRows': {'type': 'array', 'items': {'type': 'object'}, 'description': 'The LEFT table: the main rows you want to keep or enrich. Each row is a JSON object; keys may differ between rows.'}, 'rightRows': {'type': 'array', 'items': {'type': 'object'}, 'description': 'The RIGHT table: the lookup rows to pull matching fields from. Each row is a JSON object.'}, 'keyMatching': {'enum': ['normalized', 'exact'], 'type': 'string', 'description': 'normalized (default): case-insensitive, trimmed, repeated spaces collapsed, 123 matches "123". exact: values must be identical.'}, 'rightFields': {'type': 'array', 'items': {'type': 'string'}, 'description': 'Only copy these fields from the matching right row, like choosing VLOOKUP return columns. Leave out to copy every right field.'}, 'leftKeyFields': {'type': 'array', 'items': {'type': 'string'}, 'description': 'The field name(s) on the left rows to match on, for example ["email"], or ["firstName","lastName"] for a composite key. Required for every joinType except union.'}, 'rightKeyFields': {'type': 'array', 'items': {'type': 'string'}, 'description': 'The matching field name(s) on the right rows, in the same order as leftKeyFields, for example ["contact_email"]. Leave out when the right rows use the same names as the left.'}, 'includeJoinInfo': {'type': 'boolean', 'description': 'On by default: every row gets _joinStatus ("matched", "left_only", "right_only") and _matchCount. Set false for rows with only your own fields.'}, 'multipleMatches': {'enum': ['all', 'first'], 'type': 'string', 'description': 'When one key matches several right rows. all (default): one output row per matching pair, like SQL. first: only the first matching right row, like VLOOKUP, so each left row appears once.'}, 'onFieldConflict': {'enum': ['prefixRight', 'keepLeft', 'keepRight'], 'type': 'string', 'description': 'When a right field has the same name as a left field. prefixRight (default): keep both, the right one renamed with rightFieldPrefix. keepLeft: ignore the right value. keepRight: overwrite the left value.'}, 'rightFieldPrefix': {'type': 'string', 'description': 'Prefix for conflicting right fields when onFieldConflict is prefixRight. Default "right_", so price becomes right_price.'}}, 'additionalProperties': False}

{'type': 'object', 'properties': {}, 'additionalProperties': False}