Arun Arunapuram (Arun A)
Incessant Technologies
Senior Software Engineer
Incessant Technologies
Arun A Member since 2015 9 posts
Incessant Technologies
Posted: October 18, 2017
Last activity: October 20, 2017
Posted: 18 Oct 2017 9:38 EDT
Last activity: 20 Oct 2017 5:29 EDT

Parse Delimited rule reading only first row

Hi All,

My requirement is reading data from A table convert it into CSV file put it on service export directory and read from that file and insert into B table in 6.2SP2v.

For this i created a activity which reads from that A table using pxRetrieveReportData and placed in ServiceExport directory using pxConvertResultsToCSV, and now to read data from directory and insert into B table i have created ServicePackage, FileService, Delimited rule, and activity to insert data into another table and a file listener to monitor that ServiceExport directory.

I tried in 7.3v everything working fine.

But its not working in6.2SP2V only first record is inserting, when i run service by giving file content not file it is inserting all the rows and one thing i used parseCSVHeader in parse segments because i don't want to insert header in B table.

Problem is with parse delimited rule.

I am attaching the screenshots of 6.2SP2v

Help me in this regard.

Thanks in advance.

Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.