topic $syn1 remove from sql table . in QlikView

$syn1 remove from sql table .

riishabhz — Wed, 25 Nov 2020 16:16:04 GMT

my sql querry in edit script:-

SQL SELECT *
FROM ETPStoreV55.dbo.SalesReturnTrn;

SQL SELECT *
FROM ETPStoreV55.dbo.CashOrderTrn;

my table view :-

why it shows $syn1 , and how can i remove it

ramasaisaksoft — Mon, 01 Jul 2019 09:42:59 GMT

We call this concept as Synthetic columns & Tables,

to Remove synthetic Keys & Tables we follow different ways

For more information below link will help you step by step

andrei_delta — Mon, 01 Jul 2019 12:21:47 GMT

Hi,

Qualify *;

NameOfTheTable:

SQL SELECT *
FROM ETPStoreV55.dbo.SalesReturnTrn;

Unqualify *;

Brett_Bleess — Mon, 29 Jul 2019 20:34:25 GMT

Design Blog post that may be helpful as well:

Regards,
Brett