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

    exporting data from sql teradata - delimiter issue

    nikhil.jog

      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