Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. 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 *;

Highlighted
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