script to join/merge table in the data model viewer. need help :(

[#1]

Hi there  Qlikers, anyone knows how to from this

to this (below) ?

1st scenario load script is :

table1:

LOAD

    Column1,

    Column2

FROM [lib://testConnection (rsmain2_administrator)/testDATA.txt]

(txt, codepage is 1252, embedded labels, delimiter is '|', msq);

table2:

LOAD

    Column1,

    Column3

FROM [lib://testConnection (rsmain2_administrator)/testData2.txt]

(txt, codepage is 1252, embedded labels, delimiter is '|', msq);

2nd scenario load script is :

table1:

LOAD

    Column1,

    Column2

FROM [lib://testConnection (rsmain2_administrator)/testDATA.txt]

(txt, codepage is 1252, embedded labels, delimiter is '|', msq);

inner join

LOAD

    Column1,

    Column3

FROM [lib://testConnection (rsmain2_administrator)/testData2.txt]

(txt, codepage is 1252, embedded labels, delimiter is '|', msq);

I have tried:

table3:

load Column1, Column2 Resident table1;

inner join

load Column1, Column3 Resident table2;

drop table table1;

drop table table2;

But it results in "NO DATA LOADED". Any knows how?

[#2]

WOW.YUP!

You are right Balraj. I had missed this "NoConcatenate"

Thanks Balraj and reshma too.

[#3]

Thanks! Arigato!