Splitting a flow of JSON file into several JSON files

Five Stars

Splitting a flow of JSON file into several JSON files

Hello,

 

I have a flow of data (JSON files) that are like :

File_1 = a_1; b_1; c_1

....

File_n = a_n; b_n; c_n

 

I want to create (if does not exist before) and update the file to have my data ordered in JSON  like the following:

A = a_1; a_2 .... a_n

B = b_1; b_2 ... b_n

 

EDIT:

 

So far I made this:

Screenshot 2019-09-21 at 12.25.40.png

 

My problem is that tFileInputJSON_3 is loaded at the beginning of the job whereas I would like it to reload at the same time than tJavaFlex_1. Because it's supposed to be a dynamic lookup, loading at the beginning retrieves "null".

 

Wouldn't say no to some help here 

 

Thx! 

Tags (3)
Five Stars

Re: Splitting a flow of JSON file into several JSON files

Update: I've tried to link the tFlowToIterate to the tJavaFlex with a "On component OK", but then I can't iterate with the tJavaFlex. Any suggestions?

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog