Data not getting loaded into table by using Concatenate /outer join

[saiyashwan]

I have data coming from 2 source tables where i need to combine both into one table.. tried using outer join .. but data is not getting loaded.. pls. see below and any insight to resolve this would help

Bridge:
Load
CLIENT,
Number,
Type,
Record_Type,
Program
UPDATE_DATE,
Service,
Rate
Resident CRMService
;
outer join Bridge:
Load
CLIENT,
claimId,
CurrentStatus,
Entry_Id,
Source_Name,
ServiceType,
Method,
[Resolved Date],
[Add Date],
Status,
Service,
Rate
Resident ClaimServices

Also tried using Concatenate , but no table found error showing up

Bridge:
Load
CLIENT,
Number,
Type,
Record_Type,
Program
UPDATE_DATE,
Service,
Rate
Resident CRMService
;
Concatenate (Bridge)
Load
CLIENT,
claimId,
CurrentStatus,
Entry_Id,
Source_Name,
ServiceType,
Method,
[Resolved Date],
[Add Date],
Status,
Service,
Rate
Resident ClaimServices

[Vegar]

Without knowing anything about your data I would.advice you to try these adjustments.

Bridge:
NoConcatenate Load
CLIENT,
Number,
Type,
Record_Type,
Program
UPDATE_DATE,
Service,
Rate
Resident CRMService
;
Join (Bridge)
Load
CLIENT,
claimId,
CurrentStatus,
Entry_Id,
Source_Name,
ServiceType,
Method,
[Resolved Date],
[Add Date],
Status,
Service,
Rate
Resident ClaimServices;

Bridge:
NoConcatenate Load
CLIENT,
Number,
Type,
Record_Type,
Program
UPDATE_DATE,
Service,
Rate
Resident CRMService
;
Concatenate (Bridge)
Load
CLIENT,
claimId,
CurrentStatus,
Entry_Id,
Source_Name,
ServiceType,
Method,
[Resolved Date],
[Add Date],
Status,
Service,
Rate
Resident ClaimServices;

[anushree1]

Can you share sample input for  both the tables