work with 2 sources

[#1]

Hi guys,

I want to work with 2 Sources in Qlikview, well thats the strenght of QV I think, but I dont know, how to manage that:

I have 2 sources like this:

S1:

KeyNr,

LName,

FName,

BDate,

Addressname,

AddressNr,

...;

SQL SELECT * FROM XDB;

S2:

NrKey,

Name,

FirstName,

BDay,

Adresse // (-> = Adressname+Nr)

...;

SQL SELECT * FROM YDB;

I have following data:

in S1(XDB) are old data from 2010- June2014

in S2(YDB) are newer data with active people from 2010 - today..

____

I want to split this in 2 types/table: Person and Adress

How can I realize that in Script ?

[#2]

Ok Thank you very much !

[rubenmarin]

Almost, Personal and Address tables should read from Temp_S1 instead of S2.

Temp_S1: //Add_data

Load NrKey...

SQL SELECT * FROM YDB

S2: //Basic data

Load KeyNr...

SQL SELECT * FROM XDB

Concatenate (Temp_S1)

Load NrKey as Keynr...

Resident S2 Where not exist('KeyNr', NrKey);

Followed by

Personal:

Load Keynr, Name,...

Resident Temp_S1;

Address:

Load Keynr, ...

Resident Temp_S1;

drop tables Temp_S1, S2;