Skip to Content
avatar image
Former Member

Look up

Hello every one, i work on EDI and in our organization we are started using PI recently, i have been trained on it but never really worked on it, now i am building a interface by my self i am almost done with ESR part but got one fileld yet to be mapped in Message Mapping.

The interface aim is to convert CSV file to XML. I am using File to File scenario using FCC.

The map requirement is like this i have been given a CSV file with columns ABCDEFGHIJKL I HAVE TO Lookup Column A on 'Cross-Ref' tab and Map Vendor Code ( column A is FRE).

The below is the Cross-Ref tab

Site Vendor Code

FRE 7TW7006

WC 7TW7005

WC2 7TW7008

Can any one help me with this please.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 12, 2011 at 11:45 AM

    Hi,

    If your requirement is like Convert file from CSV to XML, then you can directly achieve this using Sender FCC.

    You can find many blogs related to that, one of it is [How to process CSV data with XI file adapter|How to process CSV data with XI file adapter]

    But can you throw some more information on what lookup you are looking for?

    Regards

    Ramesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 12, 2011 at 11:38 AM

    Chandrika,

    can you tell us

    Like how are you accessing the Cross ref tab? Is it another file?

    What is your source file then?

    Regards

    Ramesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 12, 2011 at 11:47 AM
    Add comment
    10|10000 characters needed characters exceeded