Question

Scotiabank
CA
Last activity: 30 Oct 2019 15:35 EDT
Using OOTB activity "pxParseExcelFile" to parse multiple sheets of the excel
Hi Dear,
I saw some article about the same activity in the Pega community, hence reaching out to you. I am trying to use the above activity to parse multiple sheets in single excel document. I am passing the following two parameters while calling this activity:-
SheetsToParse: "SheetName1,SheetName2"
SheetwiseData: true
But the output I am getting:-
PageName.pySheet(SheetName1).pySheet(SheetName2).pxResults(1).prop1
but ideally it should be:-
PageName.pySheet(SheetName1).pxResults(1).prop1
PageName.pySheet(SheetName2).pxResults(1).prop2
Please suggest!
***Edited by Moderator Marissa to update platform capability tags****