Skip to Content
author's profile photo Former Member
Former Member

CSV Lookup to validate the .TXT file

Hi All,

I am trying to validate the input file's A.txt customerID to other existing B.txt files CutomerID. Once if the input file matches the target files customerID then I am going write this output file as C.txt file.

Hope we can do this with the help of CVS Lookup. If we need to use the CVS Lookup what all are the thing need to setup and how I need to create a .java file in NWDS or just any text editor I can achieve this? And I can import it in the Imported Achieves in ESR.

We can do this using the UDF.

I checked all the below links and I am not clear about this.

http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=(J2EE3417300)ID1453571650DB01760580483263408018End?blog=/pub/wlg/2800

http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=(J2EE3417300)ID1453571650DB01760580483263408018End?blog=/pub/wlg/2926

http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=(J2EE3417300)ID1453571650DB01760580483263408018End?blog=/pub/wlg/2781

I checked with other blog too and they are importing some java .jar file as a DRIVER in the Imported Archive. Where can I get that DRIVER.jar file to import it in to my Imported Archive in ESR.

Please can any one throw the light on it. Thanks for all you inputs.

Thanks,

Jane F.

Edited by: Jane Fraga on Oct 7, 2009 5:12 PM

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Oct 07, 2009 at 04:59 PM

    Hi Jane,

    There is no CSV lookup available in PI.

    According to me you have to write the custom module to achieve this requirement, because you need to check the Customer ID in another file.

    > I checked with other blog too and they are importing some java .jar file as a DRIVER in the Imported Archive. Where can I get that DRIVER.jar file to import it in to my Imported Archive in ESR.

    send that file to the BASIS people they will deploy that file in the PI server.

    Regards

    Ramesh

    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.