AnsweredAssumed Answered

How to Populate data from XML(including tags) to Database

Question asked by naveenaboppana558916 on Jul 10, 2016
Latest reply on Jul 11, 2016 by Adam Arrowsmith

Hi ,

We are having a requirement where we are supposed to populate entire data(including tags) from an XML to a column in an Redshift database.

->Redshift database has Target table with 3 columns in it (ShowId,Data,Update).

->ShowId should be populated with the id (from Xml source).

->Date Column should contain system date(which i'm able to get)

->Update column should contain entire data from <show> to</show>(including tags)

Please find the attachment below.

Can some one help me on this please .

Thanks in advance