Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
spikenaylor1
Creator
Creator

Table Data Linking

Our process is based on batch numbers

we have 10 processes that all use the one batch number.

 

on the odd occasion the Batch Number can change after process 1.

so in that scenario

Process 1 - Batch Number ABC1234

Process 2 - Batch Number ZZZ6754

Process 3 - Batch Number ZZZ6754

 

My 1st data source outputs the data like this

Process       BatchNumber    Linked_BatchNumber       CorrectedBatchNumber

Prc1               ABC1234                 ZZZ6754                                   ABC1234,ZZZ6754

Prc2               ZZZ6754                 ABC1234                                   ABC1234,ZZZ6754

Prc3               ZZZ6754                 ABC1234                                   ABC1234,ZZZ6754

 

My 2nd data source contains records that record issues during the process. a Batch number is captured.

ABC1234  - issue recorded

ZZZ6754 - issue recorded

 

I need to be able to load the two separate data sources, but tie them together via the CorrectedBatchNumber field

 

so when I select the CorrectedBatch Number, I can chart, display all data from all sources. i.e for CorrectedBatchNumber I see the Issues for batches in the 2nd data source

 

can anyone help with how to load, join, or create a link between the tables

 

many thanks for looking

 

1 Solution

Accepted Solutions
Vegar
MVP
MVP

LOAD
Process,
BatchNumber,
Linked_BatchNumber ,
AUTONUMBER(CorrectedBatchNumber) AS %LinkId
FROM FirstData;

LinkTable:
LOAD DISTINCT
AUTONUMBER(CorrectedBatchNumber) AS %LinkId,
SUBFIELD(CorrectedBatchNumber, ',') AS LinkedBatchNumber
FROM FirstData

LOAD
BatchNo as LinkedBatchNumber,
[Issue recorded]
FROM SourceTwo ;

View solution in original post

2 Replies
Vegar
MVP
MVP

LOAD
Process,
BatchNumber,
Linked_BatchNumber ,
AUTONUMBER(CorrectedBatchNumber) AS %LinkId
FROM FirstData;

LinkTable:
LOAD DISTINCT
AUTONUMBER(CorrectedBatchNumber) AS %LinkId,
SUBFIELD(CorrectedBatchNumber, ',') AS LinkedBatchNumber
FROM FirstData

LOAD
BatchNo as LinkedBatchNumber,
[Issue recorded]
FROM SourceTwo ;
spikenaylor1
Creator
Creator
Author

Many thanks for your solution

Got it all working now correctly and all data links together.