errors of semicolumn during the generation of JSON file

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

 

 

 


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

 


All Replies
Forteen Stars TRF
Forteen 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

 

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.