Six Stars

errors of semicolumn during the generation of JSON file

Hi,

 

I have another question yet ! I am still working on this job :

 

talend.png

 

I success from "tFileInputDelimited_1" throught " tWriteJSONField_1" to generate a json file on "tFileOutputDelimited_1".

 

"tFileInputDelimited_1"

Screenshot_1.png

 

"tFileOutputDelimited_1"

 

Screenshot_1.png

 

The problem is the multiple occurrences of " ; " a the end of the file. How could I erase automatically during the generation of the file "tFileOutputDelimited_1" ?

 

Here It is the " tWriteJSONField_1" :

Screenshot_1.png

 

If you could suggest anything during my searching ...

 

Thanks in advance

 

 

 

  • Data Quality
1 ACCEPTED SOLUTION

Accepted Solutions
Six Stars

Re: errors of semicolumn during the generation of JSON file

Hi,

 

Thanks for the piece of advice !

Actually I put "space" in separator field and It works !

The problem is resolved !

Screenshot_1.png

 

2 REPLIES
Seven Stars TRF
Seven Stars

Re: errors of semicolumn during the generation of JSON file

Probably because the output schema contains 5 fields and the field separator or the tFileOutputDelimited is ";".
Change the schema to a single field or use tFileOutputRaw instead of tFileOutputDelimited.
Hope this helps.

TRF
Six Stars

Re: errors of semicolumn during the generation of JSON file

Hi,

 

Thanks for the piece of advice !

Actually I put "space" in separator field and It works !

The problem is resolved !

Screenshot_1.png