topic why do i have a table that i did not generate called $Syn 1 Table? how can i get rid of it? in App Development

why do i have a table that i did not generate called $Syn 1 Table? how can i get rid of it?

Nemo1 — Fri, 15 Nov 2024 21:01:41 GMT

when i load my data i get the following: "1 synthetic key"

greetings..

the data for one reason is not loading how i wanted to

Re: why do i have a table that i did not generate called $Syn 1 Table? how can i get rid of it?

Dataintellinalytics — Wed, 13 Mar 2024 12:33:42 GMT

It means you have more than one common column between tables. You can rename or comment any one of the field or if you need join based on both fields make it as a single composite key.

Please refer to https://youtu.be/BE8Nx23KTWs it might help.

Re: why do i have a table that i did not generate called $Syn 1 Table? how can i get rid of it?

MatheusC — Wed, 13 Mar 2024 12:33:59 GMT

Hi, @Nemo1

You didn't share any examples regarding your question, which makes it difficult to interpret the case. Regarding the synthetic key, see this qlik help documentation with the explanation:

https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/LoadData/synthetic-keys.htm#:~:text=O%20Qlik%20Sense%20trata%20essa,mem%C3%B3ria%20e%20afetar%20o%20desempenho.

Regarts, Matheus

Re: why do i have a table that i did not generate called $Syn 1 Table? how can i get rid of it?

Nemo1 — Wed, 13 Mar 2024 12:43:08 GMT

thank u!