topic Re: Integrate Data from different databases into one database in the script in QlikView

Integrate Data from different databases into one database in the script

thanhphongle — Mon, 07 Nov 2016 12:05:45 GMT

Hello Community,

is there any possibily to integrate via the script one database in another database in which the attributes are a bit different?

Example:

DB I

These are my attribute which I usually use in the script:

RecID

FirstName

MiddleName

LastName

Address

City

State

ZIP

POBox

POCityStateZip

SSN

DOB

DB II

Now I always get different types of databases from our customers which are almost the same. The attributes look like this:

RecID

Name

Address

City State Zip

PO Box

POCity State Zip

SSN

DOB

If you look at the second DB, you' ll see that the attributes are summarized or have different names for example Name is not sepperated in FirstName, MiddleName and LastName, City State Zip is one attribute etc.

Can we solve the integration from DB II into DB I via script ?

Or is it only possible to do it before the script? If its not possible, could anyone maybe give me a solution how I can solve this problem in Excel at least?

Unfortunetly I m not a database pro, hope you can help me out here.

Re: Integrate Data from different databases into one database in the script

Gysbert_Wassenaar — Mon, 07 Nov 2016 12:09:36 GMT

Simply concatenate the data

CONNECT ...etc to DB1 ;

MyTable:

LOAD * FROM DB1_source_table;

DISCONNECT;

CONNECT ...etc to DB2 ;

CONCATENATE (MyTable)

LOAD * FROM DB2_other_source_table;

Re: Integrate Data from different databases into one database in the script

thanhphongle — Mon, 07 Nov 2016 13:32:38 GMT

hmm I dont really get it.

Or can you giive me an example. I attached two databases (relationA and relationB) and my qv file

In the Database relationA the attribute Name summarizes FirstName MiddleName and LastName.

Can you show me how I can get these 3 attributes from relationB into relationA?

Re: Integrate Data from different databases into one database in the script

Gysbert_Wassenaar — Mon, 07 Nov 2016 13:45:54 GMT

Qlikvew reads from databases. It does not write to databases. You're using the wrong tool if you want to write data from one database to another database.

But if you want to load data from two different sources and combine that data into one final table in your Qlikview document then you use the CONCATENATE directive like I posted above.