TPT Load with Double Quotes Error

Tools & Utilities
Highlighted
Enthusiast

TPT Load with Double Quotes Error

Hi, everyone, I have a problem about the tpt load with double Quotes. Raw Data: 【1|"BAND-AID 1\""|ADHES】 and 【2|"INFUSION SET 42\" 9MM"|IV】 Attention: 【\】is【¥】in the raw data file. ① when Parametes : VARCHAR RecordErrorFileName =@RecordErrorFileName, VARCHAR Format = 'Delimited', VARCHAR TextDelimiter = '|', VARCHAR QuotedData = 'N', VARCHAR AcceptMissingColumns = 'N', VARCHAR AcceptExcessColumns = 'N', VARCHAR TruncateColumnData= 'N', The job is OK. And the data is the same as raw data. ②when Parametes : VARCHAR RecordErrorFileName =@RecordErrorFileName, VARCHAR Format = 'Delimited', VARCHAR TextDelimiter = '|', VARCHAR QuotedData = 'Optional', VARCHAR AcceptMissingColumns = 'N', VARCHAR AcceptExcessColumns = 'N', VARCHAR TruncateColumnData= 'N', the data is sent to my error file. What should I do ?
Tags (2)

Accepted Solutions
Teradata Employee

Re: TPT Load with Double Quotes Error

Hi Ruby,

 

Add this attribute in your load operator :

varchar EscapeQuoteDelimiter = '¥'

 

1 ACCEPTED SOLUTION
1 REPLY 1
Teradata Employee

Re: TPT Load with Double Quotes Error

Hi Ruby,

 

Add this attribute in your load operator :

varchar EscapeQuoteDelimiter = '¥'