6 Replies Latest reply on Jun 17, 2018 4:41 PM by nikhil.jog

    exporting data from sql teradata - delimiter issue


      I am exporting data from sql terdata.

      Teradata provides below delimiter options and i can also enclose column data in double quotes or in single quotes or none


      my data has a lot of textual data and i cannot guarantee that any delimiter from the below list is not going to be in my data.


      I tried | delimiter but it affected few rows too as | was in one of the cells


      How could i ensure that Tableau reads data correctly? is there a way to use delimiter along with "enclose column data" option?




      Teradata SQL Assistant - Export Data