How to eliminate the duplicate field values on join concept in qlikview

[#1]

This is my script i am getting the tables on oracle server this is my sql script and result.

but wrote the script on QlikView the data displayed  like this.

the result of the dashboard in the qlikview is.

here the duplicate values are displayed how to eliminate duplicate values.

[ashfaq_haseeb]

Hi,

For  this to work you have to have same field name for joining field.

For  more details on joins, have a look at below post.

QlikView Joins

Comparison of Oracle and Qlikview Joins.................

Regards

ASHFAQ

[CELAMBARASAN]

In Qlikview to make a join between two tables atleast one field should be in same name (it will be the key field).

Try below script

SELECT * FROM Customer

INNER JOIN

SELECT *, O_ID AS ID FROM Orders;

[jyothish8807]

Hi Pu,

Try taking sum(salary) and sum(amount) and remove o_date from your chart.

Since there are multiple o_date for a single customer it will give multiple entry.

Regards

KC

[tresesco]

You can run the SQL statement (AS-it-is) in qv like:

SQL Select ......join... on customer.id=order.o_id;

To have similar result using qv statement you have to make sure that the field name (from both table) be same while joining. Hence could try like:

Load

          id,

          ... From <>;

Inner Join

Load

          o_id as id,

          .. From <>;

[Anonymous]

try this:

select * from customer

inner join

select *, O_ID as ID from orders;