Infer implicit relationships between tables from field metadata — infer_implicit_relationships • twbparser

Generates candidate join pairs by:

Matching semantic_role across different tables.
Matching field names (case-insensitive) across different tables.

Usage

infer_implicit_relationships(fields_df, max_pairs = 50000L)

Arguments

fields_df: A data frame like the output of extract_columns_with_table_source().
max_pairs: Maximum number of candidate pairs to return (default 50,000).

Value

A tibble with columns:

left_table: Left table name.
left_field: Left field name.
right_table: Right table name.
right_field: Right field name.
reason: Why the pair was suggested.

Examples

if (FALSE) { # \dontrun{
fields <- extract_columns_with_table_source(xml)
infer_implicit_relationships(fields)
} # }