Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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