topic Synthetic Key in App Development

Synthetic Key

seraphis — Tue, 21 Dec 2021 21:56:36 GMT

I am creating a new table Case4 from another called Case1. My code does work but I get a synthetic key warning. Why is this happening and how to avoid it?

Case4:

Load Case_Flat_Case.Case_Number, Case_Flat_Case.Asset_Serial_Number, Case_Flat_Case.Date_Time_Opened
Resident Case1
order by Case_Flat_Case.Asset_Serial_Number,Case_Flat_Case.Date_Time_Opened asc;

Thanks

Re: Synthetic Key

Anil_Babu_Samineni — Thu, 13 May 2021 13:29:31 GMT

Hello, You will find lot of information If you find in Google : Link is Here

Also, For now If you are doing transformation from Case1 to Case4. You can try this?

Case4:

NoConcatenate

Load Case_Flat_Case.Case_Number, Case_Flat_Case.Asset_Serial_Number, Case_Flat_Case.Date_Time_Opened
Resident Case1
order by Case_Flat_Case.Asset_Serial_Number,Case_Flat_Case.Date_Time_Opened asc;

Drop Table Case1;

Re: Synthetic Key

seraphis — Thu, 13 May 2021 13:51:14 GMT

Hi Anil,

thanks but I am pulling only a few fields from Case1. I do not want to drop Case1.

Is it necessary to write NoConcatenate after the name of the new table? I am under the impression that it should be before that.

Re: Synthetic Key

Anil_Babu_Samineni — Thu, 13 May 2021 14:46:25 GMT

May be refer, Left Keep?

Also, Please use above link which I refered in my previous post.

Re: Synthetic Key

seraphis — Mon, 17 May 2021 09:04:35 GMT

thanks Anil.

Can you please look into this also

https://community.qlik.com/t5/App-Development/Code-not-working/m-p/1808291#M65818