topic Re: value outside the json array in Data Quality

value outside the json array

Anonymous — Thu, 15 Jun 2017 10:30:56 GMT

Hi everybody,

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

Here is my job :

I have this file at the end of my job :

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

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,

Re: value outside the json array

vapukov — Thu, 15 Jun 2017 11:08:57 GMT

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

Re: value outside the json array

Anonymous — Thu, 15 Jun 2017 14:08:05 GMT

Hi,

I show you more details :

row1 :

row2 :

row3 :

Here are the details of my tFileOutputDelimited :

Here are the details tWriteJSONField :

Anyone has an idea about my problem ?

Thanks

Re: value outside the json array

vapukov — Thu, 15 Jun 2017 14:21:48 GMT

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 " ")