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

value outside the json array

Hi everybody,

 

During my searching, I would like some advice about this thing.

 

Here is my job :

 

0683p000009LvV2.png

 

I have this file at the end of my job :

0683p000009Lvew.png

 

When I launch the job with the mode " debug of the traces "

0683p000009LtG6.png

 

I don't understand why in the Json file in notepad ++ the value of the date is outside the structure and not in the value "created".

 

Could you explain me why ?

 

Thanks in advance,

 

 

Labels (3)
3 Replies
vapukov
Master II
Master II

something wrong in previous components

 

You need attach more information about - how You prepare JSON and how add column created, from current pictures it not seen

Anonymous
Not applicable
Author

Hi,

 

I show you more details :

 

row1 :

0683p000009LvGJ.png

 

row2 :

0683p000009LvF1.png

 

row3 :

 

 

Here are the details of my tFileOutputDelimited :

0683p000009LvfB.png

 

Here are the details tWriteJSONField :

0683p000009LvWQ.png

 

Anyone has an idea about my problem ?

 

Thanks

 

vapukov
Master II
Master II

if return to Your question:

 

I don't understand why in the Json file in notepad ++ the value of the date is outside the structure and not in the value "created".

where on last screenshots - date? You do not have it JSON

 

in JSON You have exactly what You add to JSON

from ID till Label

so if You somewhere (not in components from pictures, may be in tJavaRow3?) add date - it will be exactly outside JSON as separate COLUMN (as You have column separator " ")