Forum Discussion

kpatnala's avatar
kpatnala
New Contributor
7 years ago

Storing each document into database table.. [xmlformatter --> generic jdbc insert]

Hi, i’m getting following error when executing “Generic Jdbc insert” snap. i have 2 data values that need to be inserted in 2 column table. mapper gives me col1, col2 each having list of 3 valu...
kpatnala's avatar
kpatnala
New Contributor
7 years ago

vish's avatar
vish
Former Employee
7 years ago

Hello Kiran, Could you share the output of the XML formatter as well as a screenshot of the mapper? Most likely, you’d need to use the JSON Splitter snap after to ‘flatten’ the data to fit into a relational database. Thanks!