When performing joins with other data frames using AI prompts, you may encounter the following error:
Error in dplyr::left_join(x = x, y = y, by = by, copy = copy, suffix = suffix, :
Join columns in `y` must be present in the data.
✖ Problem with `column_name`.
This error is caused by an incorrect join key specification. When you don’t use “@data_frame” to specify the data frame in your prompt instructions, the AI may not know which key to use for the join and may specify an incorrect key. Therefore, please type “@” to reference the data frame.
When the data frame is properly recognized, it will be highlighted with a light blue border.
