Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Ok Thank you very much !
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;