topic Re: which join i need to use in QlikView

which join i need to use

Anonymous — Thu, 19 Sep 2013 11:20:03 GMT

hi i have two tables

table1 conatins fields

table1 table2

field1 field2 field2 field3

A 1

B 2 3 y

C 3 4 z

D 4 5 p

6 q

now i want the result with 1,2,5,6 records of field2 in both table.

Re: which join i need to use

jonathandienst — Thu, 19 Sep 2013 11:32:40 GMT

Try this:

LOAD field1, field2

FROM table1;

LOAD field2, field3

FROM table2

Where not exists(field2)

;

Regards

Jonathan

Re: which join i need to use

jagan — Thu, 19 Sep 2013 11:41:21 GMT

Hi,

Try this

Data:

LOAD field1, field2

FROM table1;

CONCATENATE(Data)

LOAD field2, field3

FROM table2

Where not exists(field2);

Regards,

Jagan.

Re: which join i need to use

Anonymous — Thu, 19 Sep 2013 12:01:15 GMT

HI I TRIED THIS BUT I AM NOT GETTING THE RESULT.

I NEED THE RESULT AS

FIELD1 FIELD2 FIELD3

A 1 -

B 2 -

- 5 p

- 6 q

Re: which join i need to use

Anonymous — Thu, 19 Sep 2013 12:01:25 GMT

HI I TRIED THIS BUT I AM NOT GETTING THE RESULT.

I NEED THE RESULT AS

FIELD1 FIELD2 FIELD3

A 1 -

B 2 -

- 5 p

- 6 q

Re: which join i need to use

jonathandienst — Thu, 19 Sep 2013 12:03:27 GMT

Do you want the data in one table? If so, use Concatenate in front of the second load.

Jonathan

Re: which join i need to use

spividori — Thu, 19 Sep 2013 12:18:21 GMT

HI.

table1 table2

field1A field1B field2A field2B

A 1

B 2 3 y

C 3 4 z

D 4 5 p

6 q

TableResult:

load field1A as field1,

field1B as field2

resident table1

where not exists(field2A,field1B);

concatenate

load field2A as field2,

field2B as field3

resident table2

where not exists(field1B,field2A);

Regards.

Re: which join i need to use

jagan — Thu, 19 Sep 2013 12:28:27 GMT

Hi,

Try like this

DataTemp1:

LOAD

field1

field2

FROM

(

ooxml, embedded labels, table is Sheet1);

LEFT

JOIN

(DataTemp1)

LOAD

field2

field3

FROM

(

ooxml, embedded labels, table is Sheet2);

Data:

LOAD

field1

field2

RESIDENT

DataTemp1

WHERE

Len

(Trim

(field3

)) = 0

;

DROP

TABLE

DataTemp1;

LOAD

field2

field3

FROM

(

ooxml, embedded labels, table is Sheet2);

LEFT

JOIN

(DataTemp2)

LOAD

field1

field2

FROM

(

ooxml, embedded labels, table is Sheet1);

Data:

LOAD

field2

field3

RESIDENT

DataTemp2

WHERE

Len

(Trim

(field1

)) = 0

;

DROP

TABLE

DataTemp2;

Hope this helps you.

Regards,

Jagan.