Question

1
Replies
38
Views
SelvashankarP Member since 2016 9 posts
Cognizant
Posted: July 19, 2020
Last activity: July 20, 2020

dynamic XML into Lookup table in Pega Robotics

Issue: I need to create a dynamic fields in lookup table based on xml.

i have an xml which comes as input to Pega Robotics. Below is the sample xml. The member count is dynamic inside family. i am trying to parse this as data table and insert into lookup table(Member1, Member2,Member3 as columns). From lookup table i shall add them to application by looping them.

<Family>

<Member1>Name, DOB, Gender, Relation</Member>

<Member2>Name, DOB, Gender, Relation</Member>

<Member3>Name, DOB, Gender, Relation</Member>

</Family>

Can anyone help please?

 

Pega Robotic Process Automation 19.1 Robotic Process Automation Healthcare and Life Sciences
Close popover
Posted: 4 months ago

How would you like your table columns to look? Would you have columns like;

  1. MemberID (1,2,3, etc...), Name, DOC, Gender, Relation
  2. MemberID (1,2,3, etc...), MemberInfo (a comma-delimited string as your example shows)

Ideally, you would do something like the attached example. With this, you can export the XML from a LookupTable to get a look at the format and then have whatever process write to it to get loaded. Let me know what format you want your lookup tables columns to be and I could put together an example for that if the attached will work for you if the attached example does not.

 
Share this page LinkedIn
Copied!