topic Re: Master detail relationship in QlikView

Master detail relationship

krishnaroopa — Fri, 19 Oct 2012 08:20:24 GMT

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

Re: Master detail relationship

hallquist_nate — Fri, 19 Oct 2012 15:29:37 GMT

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

Nate

Re: Master detail relationship

Fri, 19 Oct 2012 15:34:49 GMT

with Qualify *;

Re: Master detail relationship

Fri, 19 Oct 2012 15:58:44 GMT

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

Re: Master detail relationship

krishnaroopa — Mon, 22 Oct 2012 06:37:15 GMT

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

Re: Master detail relationship

Mon, 22 Oct 2012 06:51:26 GMT

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