topic How to avoid $Syn Table? in QlikView

How to avoid $Syn Table?

Mon, 20 Dec 2010 02:54:20 GMT

Hi,

I have four SQL queries serving for four different sub problems. When I load data, it will automatically create $syn table. However, I want to remove them. I used "Nonconcatenate Select", it did not avoid the implicit concatenate. Can anyone help me here?

Thanks

Danni

How to avoid $Syn Table?

Mon, 20 Dec 2010 03:35:42 GMT

use an alias to the fields or the qualify/unqualify function.

How to avoid $Syn Table?

Mon, 20 Dec 2010 05:22:36 GMT

Hi Danni,

to avoid syn keys:

please give Qualify *; before the tables,

after that if u want to unqualify any field to map those tables. Please give Unqualify Field_name1,......;

Hope its very useful.

Thanks & Regards,

Sri

How to avoid $Syn Table?

Mon, 20 Dec 2010 05:43:26 GMT

Thanks Sri and mOngkz. I successfully avoid the $syn table.

Thanks once again!

Danni