errors of semicolumn during the generation of JSON file

Highlighted
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
Fifteen Stars TRF
Fifteen 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

 

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Introduction to Talend Open Studio for Data Quality

Find out about Talend Open Studio for Data Quality

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read