Discussion Board for collaboration related to QlikView App Development.
I am using QV 11, with data from sql 8.
In sql8, I have 2 tables:
1. shipment with columns - dbsource, id, shipdate amt
2. charges with columns - dbsource, id, code, amt
Charges table has the split up of charges for individual shipments
To load the data from these tables, i used left keep and had the data loaded
//Select * from Table1;
//left keep select * from Table2;
But it results in synthetic key table, how can this be avoided?
Alias the columns that are joining, that shouldn't be. I like to qualify the tables, like "SourceTable.FieldName".
with Qualify *;
May be your tables have more then 1 field common in both. so please alias the columns. There can be only 1 common field in both tables to complete data modal.
Hope it will help you.
yes, I have 2 columns in common, that is required to join the table / select the record,
I cannot change that, what can be done?
Hi, Will you post your script along with column's name. In your first post you used * in script insted of * use column names (All column) and post.
Then only I can suggest some thing