Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

max_qlik
New Contributor

Two Tables Join

Hi, how can I merge these two tables and obtain output in jpg attachment?

Thank You very much!!!!!

3 Replies
YoussefBelloum
Esteemed Contributor

Re: Two Tables Join

Hi,

TAB1:

LOAD

        autonumber(Rows&field1&field2) as key,

        Rows,

        field1,

        field2,

        field3

FROM TAB1;

OUTER JOIN

TAB2:

LOAD

          autonumber(Rows&field1&field2) as key,

          field4

FROM TAB2;

lironbaram
Honored Contributor II

Re: Two Tables Join

load *

from Tab1;

join

load Rows,Field4

from Tab2

prma7799
Honored Contributor III

Re: Two Tables Join

Please check

Community Browser