Would it be possible to have some example of such transform?
On Mon, Sep 3, 2018 at 4:18 AM DEHAY Aurelien <aurelien.de...@faurecia.com> wrote: > Hello. > > > > I would flatten the records with jolt, with a kind of flag to know if it’s > “root” data or not. Then I would extract the flag in an attribute with > evaluatejson path, and at the end route with RouteOnAttribute. > > > > *Aurélien* > > > > *From:* l vic [mailto:lvic4...@gmail.com] > *Sent:* samedi 1 septembre 2018 01:34 > *To:* users@nifi.apache.org > *Subject:* saving record into different tables? > > > > Hi, > > I have a json record that contains array "mylst": > > { > > "id": 0, > > "name": "Root", > > "mylist": [{ > > "id": 10, > > "info": "2am-3am" > > }, > > { > > "id": 11, > > "info": "3AM-4AM" > > }, > > { > > "id": 12, > > "info": "4am-5am" > > }] > > > > } > > I have to save root data into one db table and array into another... Can > someone recommend an approach to "splitting" of record for 2 different > database writers? > > Thank you, > > V > > This electronic transmission (and any attachments thereto) is intended > solely for the use of the addressee(s). It may contain confidential or > legally privileged information. If you are not the intended recipient of > this message, you must delete it immediately and notify the sender. Any > unauthorized use or disclosure of this message is strictly prohibited. > Faurecia does not guarantee the integrity of this transmission and shall > therefore never be liable if the message is altered or falsified nor for > any virus, interception or damage to your system. >