Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

riishabhz
Contributor

$syn1 remove from sql table .

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 itqlikview xyz.png

1 Solution

Accepted Solutions
ramasaisaksoft
Valued Contributor III

Re: $syn1 remove from sql table .

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/

View solution in original post

3 Replies
ramasaisaksoft
Valued Contributor III

Re: $syn1 remove from sql table .

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/

View solution in original post

Partner
Partner

Re: $syn1 remove from sql table .

Hi,

Qualify *;

NameOfTheTable:

SQL SELECT *
FROM ETPStoreV55.dbo.SalesReturnTrn;

Unqualify *;

 

Support
Support

Re: $syn1 remove from sql table .

Design Blog post that may be helpful as well:

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

Regards,
Brett

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.