Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

errors of semicolumn during the generation of JSON file

Hi,

 

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

 

0683p000009Ltpj.png

 

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

 

"tFileInputDelimited_1"

0683p000009LuWX.png

 

"tFileOutputDelimited_1"

 

0683p000009LuGC.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" :

0683p000009LuCa.png

 

If you could suggest anything during my searching ...

 

Thanks in advance

 

 

 

Labels (3)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi,

 

Thanks for the piece of advice !

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

The problem is resolved !

0683p000009LsGW.png

 

View solution in original post

2 Replies
TRF
Champion II
Champion II

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.
Anonymous
Not applicable
Author

Hi,

 

Thanks for the piece of advice !

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

The problem is resolved !

0683p000009LsGW.png