Question

3
Replies
914
Views
Suraj K (SurajK48)
TCS

TCS
IN
SurajK48 Member since 2014 7 posts
TCS
Posted: July 19, 2018
Last activity: July 26, 2018
Posted: 19 Jul 2018 10:47 EDT
Last activity: 26 Jul 2018 7:52 EDT
Closed

Convert to CSV - embedded properties

Hi,

I am required to create a csv extract for which i am using the OOTB activity "pxConvertToCSV".

This activity uses page list property as a param to convert the pagelist to a csv file.

I am using a report definition to get the list of values that is to be converted to CSV. However in the report definition i have a Declarative Index Join defined in the data access tab. Hence the pxResults for the report difinition has a page structure with embedded properties as below.

>Property1

>Property2

>> pxPages(Index).Property1

>>pxPages(Index).Property2

so as params for the ootb activity pxConvertToCSV I am giving the names of property and i am also including the embedded property as it shows in the clipboard (pxPages(Index).Property1). But it is throwing an error which says "Invalid Param - Property cant be subscripted"

Although i am able to get the csv string for those embedded properties individually using pxDataManipulate.pxConvertoCSVString which is another function.

But i dunno how to include this csv string into the CSV extracted file.

Is there any way or should i include it in the JAVA code of the pxConvertToCSV activity.

Please help me with this. If i have to include in the JAVA tell me how.

Data Integration Java and Activities Case Management Reporting
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.