Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

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

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

2 Replies
Highlighted
Partner
Partner

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

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;

 

 

 

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Highlighted
Specialist II
Specialist II

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

Can you share sample input for  both the tables