topic Re: Different behavior between Studio and TMC when using parameters for tFileOutputDelimited in Talend Studio

Different behavior between Studio and TMC when using parameters for tFileOutputDelimited

quentin-vigne — Wed, 07 Aug 2024 12:25:24 GMT

Hello everyone,

Has anyone encountered this error ?

If I use parameters for a tFileOutputDelimited (for field separator, row separator and filename) the output is different between TMC and Studio even if parameter values are the same (for example "\n" and ";")

For example when outputing from the studio execution the file is normal.

However when doing the exact same from the TMC all the field are encased in double quotes : "example"

And the first field of the first row only has 1 double quote like : other_example"

and there is a single double quote at the end of the file.

A colleague of mine in a different work environnement encounter the same issue

What's the problem here ?

Re: Different behavior between Studio and TMC when using parameters for tFileOutputDelimited

Shicong_Hong — Thu, 08 Aug 2024 06:04:46 GMT

If you use Remote Engine to run the job on TMC, go check if the machine where Remote Engine is installed is the same operating system type as the machine where studio is installed. This issue may be caused by different row separator in different operating systems.

Regards

Shicong

Re: Different behavior between Studio and TMC when using parameters for tFileOutputDelimited

quentin-vigne — Thu, 08 Aug 2024 07:30:06 GMT

Yes it's the same OS.

We don't use a OS specific row separator we use this :

with

context.tfile_row_separator = "\n"

context.tfile_field_separator = ";"

and on the TMC :

My colleague on a different work env even has the remote engine on the same machine as the studio and has the same problem

and this is the 2 files generated, on the left the one generated by the TMC and on the right the one generated by the studio. We want the output to always be like the one on the right