Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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