left join issues

[marksmunich]

I have created a a table using the inline . i hvae 3 columns in it, where is the last column has the value for the no of planned hours like 600, 400, 600 etc. this table has 6 rows. i have performed a left join fo this table to the fact table using a left join. which has other fields such as no of worked hours. the total planned hours is 2800 hours per year . in a bar chart i have tried to display the planned hours and work hours, but something is going wrong with the planned hours column which i have created using inline. it is unable to display its value in either lists or in the bar charts.

[#2]

Hi,

Make sure that you have applied left join based on primary key i.e unique and not null field.

And that field name should be the same in both the tables.

You can't left join on the basis of planned hours(this is not unique field).

Hope this helps you.

[marksmunich]

It is based on the unique key and none of the values are null.

[jpapador]

Does the unique key from your inline table have matching values in the key field of the table you are joining to?

[marksmunich]

yes it does have. only then its possible to join. i have joined as well. In the resultant table, the newly added table colum has total null values.

[#6]

check left join in correct way some time may  u join with right table