Question

262
Views
ChampakSLF Member since 2019 1 post
Scotiabank
Posted: October 30, 2019
Last activity: October 30, 2019
Closed

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

Low-Code App Development Data Integration
Moderation Team has archived post
Share this page LinkedIn