Data load editor

Qlikuser09 — Wed, 08 Sep 2021 21:32:36 GMT

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.

Re: Data load editor

MayilVahanan — Thu, 09 Sep 2021 03:30:59 GMT

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