Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 12, 2011 at 11:47 AM
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.