Hi Boomi folk
I have the below problem
This is a simplified version of my Database row
I'd like to Ideally map this in a single pass to XML Similar to below
There maybe upto 100 CSV groups (5 characters each) in the groups column
these are strictly controlled to not contain any CSV chars
<?xml version='1.0' encoding='UTF-8'?>
I'm still on the trial version of boomi but working on an integration heading towards UAT (sound familiar ?)
I've had a good search through his forum but not really find exactly this issue
so maybe I'm just approaching it from a too simplistic angle.
I did try passing in a pre <> tagged groups field from SQL but the < kept getting escaped out (<) as that looked promising in the source but the boomi target XML mapping auto escaped it.
I'm open to Groovy scripting , splitting documents
but mainly the most efficient way to handle this little issue.
Many thanks for your time and input