Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Master detail relationship

Hi

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

//QVTab1:

//Select * from Table1;

//QVTab2:

//left keep select * from Table2;

But it results in synthetic key table, how can this be avoided?

Thanks

KRS

5 Replies
Highlighted
Partner
Partner

Alias the columns that are joining, that shouldn't be.  I like to qualify the tables, like "SourceTable.FieldName".

Nate

Highlighted
Not applicable

with Qualify *;

Not applicable

Hi Krishnaroopa,

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.

Regards

-Anil

Highlighted
Contributor
Contributor

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?

regards

KRS

Highlighted
Not applicable

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

Regards

Anil