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

Announcements
Join us in Bucharest on Sept 18th 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