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)
Forteen Stars

Re: How to get tExtractJsonFields output multiple rows

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

then - tNormalize

 

 

-----------

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch