Question
Ford Motors Private Limited
IN
Last activity: 20 Jul 2020 12:33 EDT
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?
Pegasystems Inc.
US
How would you like your table columns to look? Would you have columns like;
- MemberID (1,2,3, etc...), Name, DOC, Gender, Relation
- 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.