Question

2
Replies
1031
Views
Vikram22 Member since 2014 17 posts
TechMahindra
Posted: 1 year ago
Last activity: 1 year 3 months ago
Closed

How to use MSOGenerateExcelFile Activity to download data which is on a Page and PageList (pxResults) ?

Below is the example of clipboard structure

workpage.Pega.Page.pylabel ----Excel

workpage.Pega.PageList(1).pynote - 123
workpage.Pega.PageList(2).pynote - 234
workpage.Pega.PageList(3).pynote - 345
workpage.Pega.PageList(4).pynote - 456

---------------------------------------------------------------------

Binary file Template

A B
workpage.Pega.PageList().pynote workpage.Pega.Page.pylabel

--------------------------------------------------------------------------

If i use MSOGenerateExcelFile Activity below is the output on excel file.

A B
1) 123 Excel
2) 234 Excel
3) 345 Excel
4) 456 Excel
---------------------------------------------------------------------------------

As per requirement downloading excel should contain values as shown below.

A B
1) 123 Excel
2) 234
3) 345
4) 456

any solutions for the requirement.

I will be grateful for any help you can provide for our requirement.

***Edited by Moderator: Lochan to update platform capability tags***

Data Integration Java and Activities Data Integration
Moderation Team has archived post
Share this page LinkedIn