Ok, I should also mention I cannot change the layout of the Delimited file,
unless I can prove there is no other solution, and still the probabilities
for the lay out of the delimited file to change are very slim.
Thnx,
WDM.
-----Original Message-----
From: Art Douglas [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 24, 2000 10:39 AM
To: Mojica William-FWM008
Cc: [EMAIL PROTECTED]
Subject: Re: FW: Harbinger Workbench lookup Xref help
William,
Why not make your look-up key a concatenation of TP ID and UPC? That way,
it
would be unique:
Look-up key Value returned
123456789-123456 abc123456
987654321-123456 ZZZ65444
Art Douglas
Mojica William-FWM008 wrote:
> > Hello everyone:
> >
> > I need some help with Harbinger Workbench. I made a map that has a
> > cross-reference to a delimited file. look for an UPC number and give me
> > the corresponding Vendor Number. It works great the only issue I just
ran
> > into is that there might be two different Vendor Numbers for the same
UPC,
> > and also different TPs
> >
> > EXAMPLE:
> >
> > Trading Partner ID UPC Vendor Code
> > 123456789 123456 abc123456
> > 987654321 123456 ZZZ65444
> >
> > When doing a Xref you will only get the first value that is found,
> > so I need to come up with something that it will also check for the
TP-ID
> > to make sure is the right VC for that TP.
> >
> > Any help will be greatly appreciated.... (God I miss
> > MERCATOR....!!!)
> >
> > William D. Mojica
> > [EMAIL PROTECTED]
> > Order Services Dept.
> > EDI Specialist
> > Motorola, Inc.
> > Phone: (561)739-2852
> > Ext. 2852
> > Two Way Pin# 7392852
> >
>
> =======================================================================
> To signoff the EDI-L list, mailto:[EMAIL PROTECTED]
> To subscribe, mailto:[EMAIL PROTECTED]
> To contact the list owner: mailto:[EMAIL PROTECTED]
> Archives at http://www.mail-archive.com/edi-l%40listserv.ucop.edu/
=======================================================================
To signoff the EDI-L list, mailto:[EMAIL PROTECTED]
To subscribe, mailto:[EMAIL PROTECTED]
To contact the list owner: mailto:[EMAIL PROTECTED]
Archives at http://www.mail-archive.com/edi-l%40listserv.ucop.edu/
