Problem import file with S3 load generator

Matillion ETL
1

Hi, i'm a newby with Matillion and i stuck with two problems. 

 

  • Import CSV file with s3 load generator: I got double quote on each value. How can I remove this " "

0694G00000RKa1AQAT_0D54G00009DOzLzSAL
0694G00000RKa1AQAT_0D54G00009DOzLzSAL658×192 13.2 KB

  • I try to import a TEXT file with S3 Load generator. 0 row is loaded. Here's my configuration:

0694G00000RKa0wQAD_0D54G00009DOzLzSAL
0694G00000RKa0wQAD_0D54G00009DOzLzSAL1187×700 45.5 KB

 

Thank you for your help!

2

If you set the "Field Optionally Enclosed By:" to double quotes (") then the double quotes will get removed from the data load.