One Star

Iterate on JSON array

Hi to all, I've a JSON file like this one:

}]

I need to get an unique record with "codiceCatastale" and "cap". So, like this:
|=--+---=|
|codiceCatastale|cap|
|=--------------+----=|
|A001           |35031|
|A271           |60121|
|A271           |60122|
|A271           |60123|
'---------------+-----'

I try with tExtractJSONFields with success...

Any suggestions?
Thanks a lot
Stefano
1 REPLY
Community Manager

Re: Iterate on JSON array

Hi  
Using a tFileInputJson component to read this json file, set the Loop Json query to "/cap", then you should be able to extract codiceCatastale and cap value. 

Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business