Hi @rahulkad29786, Were you able to figure out a way, on this, if you please share Regards,Dipendu

Hi @Shruti1 , Try this piece of codevar str = dValue; var regex = /schema="(.*?)"/g; var matches = str.match(regex);  It should extract all schema's from the XML in an array. From there you can further filter and get the FDA tables, filtering on namespaces Regards, 

Hi @Sukrity_Wadhwa, Any update, when this program will start  Regards,Dipendu

Hi @_Manoj_Kumar_ , Can you help with an example, if possible ? Regards,DG

There is no change, I mean no column is added after the transition. I used Varchar instead of NCLOB. Can somebody please post the setup, if possible Regards,DG

Hi @AkshayAnand, @_Manoj_Kumar_, The requirement is to create a new SQL function so that can be easily used by the Campaign Managers, like other SQL functions Is 255 Characters max in case of temporary table created in workflow, or can they be extended to hold larger value  Regards,DG

Hi @_Manoj_Kumar_ , Can you show me with an example as the StringAgg function is using the @firstName  field of recipient. It will help  Regards,DG 

Hi @_Manoj_Kumar_ ,  

Hi @_Manoj_Kumar_  ODB-240000 ODBC error: String '...' is too long and would be truncated SQLState: 22000The String size is greater than 255, so this error, else it works fine  Regards,DG

Hi @_Manoj_Kumar_  This is the setup.      Regards,DG