Store SQLinput in json files, one row in one file

One Star

Store SQLinput in json files, one row in one file

Hi!
I want build a job, which will read sql table and store each row in json file.
Which job structure is better for this?
Dmitry.
Seventeen Stars

Re: Store SQLinput in json files, one row in one file

tOracleInput ----> tFileOutputJSON
Or do I miss something from your use case?
Did you mean every row in its own JSON file?
In this case:
tOracleInput ----> tFlowToIterate ----> tFixedFlow (set the variables from tFlowIterate!) ----> tFileOutputJSON (use any variable from tFlowToIterate to build the file name)