Discussion Board for collaboration on QlikView Scripting.
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 ?
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 .
TDS Technology (S) P/L
May be Concatenate for AR Table with Sales Table
Load * FROM "$(vFileName)" (ansi, fix, no labels, header is 0, record is line); ;
LOAD * FROM "$(vFileName)" (ansi, fix, no labels, header is 0, record is line);