Hello,
We need to export all table and views from Database to CSV file through Appian process. The environment is setup in Appian cloud. The column data should be enclosed in double quotes and comma separated - like in example below:
"column header1","column header2"
"col1-value1","col2-sample-value2"
"col1-value2","col2-sample-value2"
We are using Export SQL to Flat File smart service to this. The headers come out with double quotes, however, the values are not enclosed in double quotes. The whole process is automated, as we do not have SQL script built do do this. We use information_schema table of MYSQL to find the tables and then use "Select *" to build the query. Can we get help on how to enclose double quotes on the column values?
Thank you,Harish
Discussion posts and replies are publicly visible