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

[paulyeo11]

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

[paulyeo11]

my qvw

[Anil_Babu_Samineni]

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?

[jonathandienst]

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

Change that to "Internal Table View":

[paulyeo11]

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

[Anil_Babu_Samineni]

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