When joining data columns, “.x” and “.y” columns are created because the two dataframes being joined contain columns with the same names.
During a join, when the same column name exists in both datasets, the system automatically adds suffixes “.x” (for the source data) and “.y” (for the target data).
The “Add Column Suffix” option in the join dialog allows you to specify custom suffixes when columns with the same name exist in both the source and target datasets during a join.
