Question
1
Replies
44
Views
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?
How would you like your table columns to look? Would you have columns like;
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.