Teradata data contains newline characters causing query results to export serial issues

Teradata data contains newline characters causing query results to export serial issues

During the daily operation of the system, part of the data is read into Excel import into the production system. This results in a mixed data quality. Some Excel cells have line breaks, data import, when queried again, it is possible to export the results of data serial problem.

First to restore the problem. (no solution has been found ...). T_T)

Write SQL and run the results such as:

Copy answer to UE view:

Export txt view using Sqla's own export function:

Note that the Create table with data is inconsistent with the insert select Run result;

Sql:

CREATE MULTISET VOLATILE TABLE vt_test as (SEL 1 as Line_num, ' first row 12345 second row 67890 third row abcde ' as MULTILINE) with DATA on COMMIT P Reserve Rows;insert into Vt_testsel2 as Line_num, ' Line1line2line3 ' as MULTILINE; SEL * from Vt_test;

　　

Teradata data contains newline characters causing query results to export serial issues