ETL and Data Integration tools - Modern ETL software for everyone

Hello,

I am trying your product before purchasing it. What I am trying to do is import a lot of records from an excel file, the problem that I have is the following:
* I need to obtain some values from the TARGET database before inserting the rows from the excel. This would be like having 2 sources for the same destination. Imagine that you are going to insert CUSTOMERS but the credit limit amount is stored in some configuration table in your target database (MYSQL) and obviously I can't insert any row from the excel because of the database constraints.
I tried with lookup fields and I tried with SQL Check Data but I didn't know how to link the result of this SQL CHECK DATA BOX to be the input of the SOURCE of my transformation block that reads the excel and insert data into the MySql Table.
Additionally, is there a possibility to have more that 1 source in the same transformation? how could I merge the content from 2 or more sources (1 excel and 1 text file for example) into 1 destination?

Please advice
Chris

Chris

I need to obtain some values from the TARGET database before inserting the rows from the excel. This would be like having 2 sources for the same destination. Imagine that you are going to insert CUSTOMERS but the credit limit amount is stored in some configuration table in your target database (MYSQL) and obviously I can't insert any row from the excel because of the database constraints.

Lookup is the best option for you.

Here is the tutorial

www.dbsoftlab.com/online-tutorials/advan...g-lookup-object.html

Additionally, is there a possibility to have more that 1 source in the same transformation? how could I merge the content from 2 or more sources (1 excel and 1 text file for example) into 1 destination?

several options
a

1 add data from excel file to the text file
2 Perform additional transformations, load it into the database

b
1 Create separate file
2 Add data from excel file into it
3 Add data from Text file into it
4 Perform additional transformations, load it into the database

c

use variables


Mike