How to search and replace in a csv file
I’m trying to design a pipeline that changes gets a zip file via sftp that contains a single csv file, then do a search and replace in the csv (in this case it is replacing all the values in a single...
Forum Discussion
@manchis I have done the same in two ways- If you can keep both the XSD in your groudplex server node then can use file::/// protocol inside parent XSD to refer child XSD. Other option is to copy the content of child xsd and paste it to parent. Remove the child xsd reference from parent, it would be like a new XSD and can use it.
You mean creating the table on the fly with snaplogic 2nd O/P and you want to create few columns on the table.
If my understanding is correct, may i know what database you are using, If you using select snap, instead try creating with a execute snap by placing the select query and give a try, Just a heads up!Hi Aravind, Yes it would be much better for me to use the Execute snap rather than the Select snap but the Execute snap does not seem to have a second output with which to pass out the table structure. I’m using JDBC snaps for the select and SQL Server snaps for the insert. The underlying database is MS SQL server on both.
