Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
my qvw
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?
You have saved it with the Table viewer in Source Table View mode:
Change that to "Internal Table View":
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
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);