left join in a loop

[adiarnon]

hi,

i have a problem -

i have 4 DB with the same tables.

im creating a model that includes data from all of the DB.

i have a loop that run on each DB (different QVDS path)

when im doing left join its creating me 4 different tables (one for each loop) and not concatenate them.

someone know why? and how can i resolve it?

tnx,

adi.

[lironbaram · Accepted solution]

hi because you are doing a left join inside the loop

when you load the PORD table from the second source it field list is different from the existing table

because it's missing the fields from the PORDERS

in the loop create two separate tables

and the do the left join out side the loop when each table has the records from all data sources