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

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

saiyashwan — Wed, 25 Nov 2020 16:16:04 GMT

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

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

Vegar — Fri, 14 Jun 2019 04:44:42 GMT

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;

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

anushree1 — Fri, 14 Jun 2019 06:08:12 GMT

Can you share sample input for both the tables