cancel
Showing results for 
Search instead for 
Did you mean: 

CSV Lookup to validate the .TXT file

Former Member
0 Kudos

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...

http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=(J2EE3417300)ID1453571650DB01760580483263408018End...

http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=(J2EE3417300)ID1453571650DB01760580483263408018End...

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Ramesh,

Yes I can understand that, their is no CSV Lookup. Instead of that in this examples they are using the JDBC Lookup and check the CSV or txt file.

Can you check this blog:

http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=(J2EE3417300)ID1453571650DB01760580483263408018End...

He is using the DRIVER file in the Imported Archives in ESR. Name of the imported file is DRIVERS.

[Message from the above blog:

Once we have the Driver we have to import that jar file in the Imported Archive area available in the Integration Repository.

Once we have imported this file now we can consider the CSV file as a Database table and access it in the Mapping program using a simple user-defined java program. ]

Thanks,

Jane F.

Former Member
0 Kudos

Hi Jane,

Then Import the driver to imported archieve. (remember you don't use the .jar extention here).

Regards

Ramesh

Former Member
0 Kudos

Ramesh,

Where can I get those Driver files as he mentioned in his blog?

Is this is the JDBC Driver's? I don't think the JDBC driver has to import in the Imported Archives in ESR.

Please can you clear me in details about the DRIVER files is he mentioned in his blog.

Thanks,

Jane F.

Former Member
0 Kudos

Hi Jane,

That Drivers we can buy from the market.

In that blog first comment is about the driver, check that comment.

Regards

Ramesh

Former Member
0 Kudos

Yes Ramesh. I already checked and need to get that and import and have to see how it works?

Thanks,

Jane F.