$syn1 remove from sql table .

[riishabhz]

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 · Accepted solution]

We call this concept as Synthetic columns & Tables,

to Remove synthetic Keys & Tables we follow different ways

• Alias Name
• Qualify/Un-qualify
• Link Table
• Remove unnecessary columns from Load script

For more information below link will help you step by step

https://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/

[andrei_delta]

Hi,

Qualify *;

NameOfTheTable:

SQL SELECT *
FROM ETPStoreV55.dbo.SalesReturnTrn;

Unqualify *;

[Brett_Bleess]

Design Blog post that may be helpful as well:

https://community.qlik.com/t5/Qlik-Design-Blog/Synthetic-Keys/ba-p/1472634

Regards,
Brett