Source Table

[Former Member]

Hello everyone,

I have 10 source tables but the operation i am going to do with that is common. I dont want to have 10 different transforms to perform the same action.

Is there any way i can pass the table name over run time ? so that all my work will be done in one go.

Any leads ?

Thanks,

AJ.

[severin_thelen]

Hello Joseph,

but every source table has a different target table? Then you have to create the query 10 times.

If all tables have the same target table you could merge the tables (merge transform) and after that you just need one query.

Regards

Severin