topic Re: integrating tables in QlikView

integrating tables

Anonymous — Tue, 09 Feb 2016 16:28:17 GMT

Hi,

I need to join 2 tables in the script in the following way:

Table1 includes Field1 with the values 1,2,3.

Table2 includes Field2 with the values a,b,c.

I need to create Table3 which integrates Field1 and Field2 in the following way:

Field1 Field2

1 a

1 b

1 c

2 a

2 b

2 c

3 a

3 b

3 c

How can I do it?

Thank you in advance,

Larisa

Re: integrating tables

swuehl — Tue, 09 Feb 2016 16:29:41 GMT

A simple JOIN should do.

LOAD Field1

FROM FIELD1TABLE;

JOIN

LOAD Field2

FROM FIELD2TABLE;

Re: integrating tables

Colin-Albert — Tue, 09 Feb 2016 16:30:30 GMT

Table1:

load

Field1

from ..... ;

join (Table1)

load

Field2

from .... ;

Re: integrating tables

sathishkumar_go — Tue, 09 Feb 2016 16:32:47 GMT

Hi,

Table3:

load field1 from Table1;

join (Table3)

load field2 from Table2;

-Sathish

Re: integrating tables

Anonymous — Tue, 09 Feb 2016 17:16:46 GMT

Thank you!