Selecting Right Record (Row) From Connected Excel Database 关注
I've tried to find anything regarding this topic on the Forum but have not seen anything that would solve my problem.
I'm retrieving data from an excel sheet based on the data given by our ERP system. Our ERP generates a text file which pinpoints what product label and values that should be printed and the data is then picked out of the excel file. This works well in one of our production lines since every "main"-record in the join is unique.
My problem in the other production lines is that the connected excel database from which I am supposed to get our label data has more then one unique "main" product record and the record row should be pinpointed with a second given data field from the generated text file.
In the attached picture you can see the two columns that are problematic. The EB-1-... beeing the "main"-record that tells what product that needs to be printed and L-2-... tells which record row of the product that needs to be chosen. We have over 21k unique EB products and some of them can have up to 100 different record rows depending on the L-2 and the same L-2 can be used in different EB's.
It's impossible to do a two row multi database join with the same text file and sheet since they both use the same databases.
How can I pinpoint which record that should be printed since I have all the data needed for it, given by the product "EB" and the attached device "L-2"?