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: 
Not applicable

How to handle synthetic keys while uploading the data in Qlik?

synthetic key.pngI am facing the new problem as there is presence of synthetic key how can i solve this?

3 Replies
its_anandrjs
Champion III
Champion III

Hi,

Rename that field or make the composite keys based on this keys.

Ex:-

Tab1:

Load

A

From Location;

Tab2:

Load

A as Tab2A

From Location;

You can use the qualify statement as well.

Regards,

Anand

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

A synthetic key is not necessarily a problem. Read this blog post first: Synthetic Keys


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author