Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

My QV cannot generate syn key , How to turn it on ?

Hi All

I have a QVW file , which when i view the data model , all syn key does not group together , may i know how to turn it on ?

Paul

5 Replies
paulyeo11
Valued Contributor II

Re: My QV cannot generate syn key , How to turn it on ?

my qvw

Re: My QV cannot generate syn key , How to turn it on ?

In your application, I didn't see any Synthetic Keys(Syn Keys - Means What here). And then, Which Field you want to club can you describe more please?

Life is so rich, and we need to respect to the life !!!
Highlighted
MVP
MVP

Re: My QV cannot generate syn key , How to turn it on ?

You have saved it with the Table viewer in Source Table View mode:

Capture.PNG

Change that to "Internal Table View":

Capture.PNG

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
paulyeo11
Valued Contributor II

Re: My QV cannot generate syn key , How to turn it on ?

If you type control T , you will notice that sales table and AR table there are individual line for cust_id & company.

These line should not be there . If the syn key is on.

I mean between each box it should only have one line. Now many line. Look very confuse .

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +659:261804

Re: My QV cannot generate syn key , How to turn it on ?

May be Concatenate for AR Table with Sales Table

sales:

Load * FROM "$(vFileName)" (ansi, fix, no labels, header is 0, record is line);  ;

Concatenate(sales)

AR:

LOAD * FROM "$(vFileName)" (ansi, fix, no labels, header is 0, record is line); 

Life is so rich, and we need to respect to the life !!!
Community Browser