Data load editor

[Qlikuser09]

I have a table listed below with a few other columns, I wanted to create a date bridge. 

customer_id

Purchase date

Location

I used 
"DateBridge:
Load
[Customer_ID]
, purchase_date as date
Resident customertable"

but it created another table named "$Syn_1 Table" and created another  primary key called $Syn1. 

[MayilVahanan]

Hi 

Qlik Sense creates synthetic keys when two or more data tables have two or more fields in common.

FYR: https://help.qlik.com/en-US/sense/May2021/Subsystems/Hub/Content/Sense_Hub/Scripting/synthetic-keys....