How to get tExtractJsonFields output multiple rows

Six Stars

How to get tExtractJsonFields output multiple rows

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

Tags (1)
Twelve Stars

Re: How to get tExtractJsonFields output multiple rows

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

then - tNormalize

 

 

-----------