Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Cbhuvi27
Contributor III
Contributor III

Synthetic key during Partial load

Hello All,

Synthetic keys are getting created when using Partial Load with ADD ONLY. Can someone help to eliminate the synthetic keys.

Labels (2)
3 Replies
mpc
Partner Ambassador
Partner Ambassador

Hi, 

You can share you script ? This will help us in the troubleshooting process. 

Kind regards

From Next Decision and mpc with love
Cbhuvi27
Contributor III
Contributor III
Author

Hello,

Load * from

largerqvd(qvd);

 

Add only

load * from

smallerqvd(qvd);

 

both the qvd have same data. Basically i n just adding some additional data using partial load

mpc
Partner Ambassador
Partner Ambassador

Quite strange, if a Synth key is created, that's mean usually that the structures of teh tables are differents, and then are not automatically concatenate. 

Can you check/share the header of the larger and smaller.qvd please, and share ouput data model Moreove, what is the table output when you do: Add only concatenate load * from smallerqvd (qvd) ? Can you try and share the data model output too ?

From Next Decision and mpc with love