Discussion board where members can get started with Qlik Sense.
I am trying to remove the synthetic key using Autonumber function..I have created Autonumber key in two tables using three columns Fox Ex- Autonumber(Date&'-'&X&'-'Y) as key..Two tables are connected through the key column but it is generating different keys for same value.Am I doing anything wrong here?
I have used date(datefield,'YYYY-MM-DD').
For first table say
Autonumber(Date&x&Y)--> key generates values from '1' to '6588'
for second table
Autonumber(Date&x&Y)--> key generates values from '6589' to '1100000'
You need to use a parameter in the AutoNumber Function to let Qlik Sense know you are wanting to use the same AutoNumber 'Set' for each table loaded.
AutoNumber(Date & '-' & X & '-' Y, 'a') as KeyField
The letter 'a' can be anything you want it to be as long as you use the same parameter is all load statements.
AutoNumber(Field1 & Field2 & Field3, 'a') as KeyField
AutoNumber(Field4 & Field5 & Field6, 'a') as KeyField
Does it work if you don't use the AutoNumber function?
Field1 & FIeld2 & Field3 as KeyField
Field4 & Field5 & Field6 as KeyFIeld