topic How to inner join on a specific field in QlikView

How to inner join on a specific field

Fri, 06 Aug 2010 07:07:54 GMT

Good day gyus How do I inner join 2 table on a specific field. I have the following data. How would the script look like if I want to join them on DocEntry??

SQL SELECT CardCode,DocDate,DocEntry,DocNum,DocType FROM "SBO_O_SA1".dbo.OPDN;

SQL SELECT DocEntry,LineTotal,Quantity,ItemCode FROM "SBO_O_SA1".dbo.PDN1;

How to inner join on a specific field

Fri, 06 Aug 2010 07:38:01 GMT

Hi Christo.

Tab1: // Name the table, so you can join it
SQL SELECT CardCode,DocDate,DocEntry,DocNum,DocType FROM "SBO_O_SA1".dbo.OPDN;

INNER JOIN (Tab1) // Join Tab1
Load DocEntry,LineTotal,Quantity,ItemCode; // Preceeding load, you join via DocEntry.
SQL SELECT DocEntry,LineTotal,Quantity,ItemCode FROM "SBO_O_SA1".dbo.PDN1;

Kind regards, Miha

How to inner join on a specific field

Miguel_Angel_Baeyens — Fri, 06 Aug 2010 08:39:04 GMT

Hello Christo,

I may have misunderstood your question but, since QlikView joins tables (links them) when both share a field with same name, I don't think forcing a join would be necessary in this case. It'a just enough to keep fields with the same name

Hope that helps.

How to inner join on a specific field

Fri, 06 Aug 2010 10:09:37 GMT

Thank you both for the help.

I know that Qlikview joins automatically. But I needed to INNER JOIN in some instances.

This was only a simple example.

Regards

Re: How to inner join on a specific field

venkat1 — Sat, 23 Mar 2019 06:34:00 GMT

Hi ,

i have a question

what if i want to join only specific row that is not there in the another table

For example ,

Table A had fields like Emp , id, name ,role

Table B had : date,place.

now my final table should look like : Emp,id,name,role,place.

How it was possible ?