discover_id_introduction_steps {acdcquery}

Discover ID Introduction Steps

Description

This function identifies the steps in a join path where new IDs are introduced, allowing you to determine at which join steps each ID variable is added to the query. It returns a data frame with information about newly discovered IDs and the corresponding join step in the path.

Usage

discover_id_introduction_steps(conn, full_path_dataframe)

Arguments

conn

The connection object or database connection string.

full_path_dataframe

A data frame representing the full join path, including columns: "table_to_join", "method", and "common_var".

Value

A data frame with information about newly discovered IDs and the corresponding join step.