How to get tExtractJsonFields output multiple rows

Anonymous — Sat, 16 Nov 2024 07:50:53 GMT

Hello.

I use tRest to Post a _search request to ElasticSearch

{

"_source": "PersonID",

"size": 20

}

and getting a proper response as expected.

Than I pass it to tExtractJsonFields with this parameters:
Read By=JsonPath,
Json field = Body

Loop Jsonpath query = "$"

Mapping =

Column = PersonID, Json query = ".PersonID"

It seems to work fine, but insead of 20 rows as output, I seem to get only 1 string row like so

[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]

How can I get it to return 20 rows to the next component?

Thanks

Re: How to get tExtractJsonFields output multiple rows

vapukov — Fri, 05 Oct 2018 11:07:19 GMT

first remove [] from begin and end of string (tMap or tReplace)

then - tNormalize