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

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

paulyeo11 — Tue, 17 Jan 2017 03:49:31 GMT

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

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

paulyeo11 — Tue, 17 Jan 2017 03:51:05 GMT

my qvw

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

Anil_Babu_Samineni — Tue, 17 Jan 2017 04:16:42 GMT

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?

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

jonathandienst — Tue, 17 Jan 2017 05:08:30 GMT

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

Change that to "Internal Table View":

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

paulyeo11 — Tue, 17 Jan 2017 05:42:13 GMT

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 ?

Anil_Babu_Samineni — Tue, 17 Jan 2017 06:09:29 GMT

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);