I'm trying to get the information to the corresponding shift team to a production batch with a given start-time.
The start-time/end-time is loaded from the qvd (oracle data) at the beginning of the script. Several QVDs follows, they are not cited here. At the end of the script external data sources are linked. 'Date' as start of the 'Shift' from an xls file should be linked to the batch (start) from the qvd data.
Either I go a synthetic key by working with the join function or I can't get a link to the shift table...
I loose my time over finding a solution in this issue.