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