tAccessInput.. MSAccess table names as parameter

[Rachidoo]

Hi,

I have an MS Access database with many tables having all names in this format : products_stock_on_01/31/2020

fields are :

product_code

product_name

product_category

stock_quantity

Each month-end a new table is generated on this database.

With a simple Talend Job, an tAccessInput component and obviously a tMap.. i want to load all tables to one SQL Server table created in the same format with an additional field "Stock_date"

How can i do please ? I don't know how to make a loop on each table with her name in parameter for the tAccessInput compoent.

Thank you

[pakapi_]

Hi Rachidoo,

first you have to get list of interesting tables, by querying system tabels f.g.:

select

MSysObjects.name

from

MSysObjects

where

MSysObjects.name like 'products_stock_on_%'

Paste this query in your first tAccessInput.

Then you have to iterate through your input, by using tFlowToIterate.

Then, use variable from tFlowToIterate to parametrize your table name in input query.

Save your fetched data into target database table.

Your job should looks like:

tAccessInput>row>tFlowToIterate>iterate>tAccessInput>row>tOracleOutput