Table Data Linking

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

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

Re: Table Data Linking

Vegar — Fri, 15 Feb 2019 19:20:01 GMT

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 ;

Re: Table Data Linking

spikenaylor1 — Mon, 18 Feb 2019 13:52:49 GMT

Many thanks for your solution

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

topic Table Data Linking in QlikView

Table Data Linking

Re: Table Data Linking

Re: Table Data Linking