How can I get Extract Json Field and Other field from DB

[Anonymous]

Hello everyone,

I'm working on job talend who consists to Export DB to Csv,

I have a field Json who I extracted data, this is OK.

But my problem is How can I get other field from my DB to put this in my Output CSV in the same time with these field json.

You can look my Job in photo

Thanks very much for your Help.

[nivedhitha · Accepted solution]

@Saitama9 ,

In addition to the columns you parsed out of the json string, add the columns from your database to the schema of tExtractJSON component and the other columns will just flow through.

Please refer to the screenshots below. I have worked out a similar example.

Pic 1 - FixedFlow instead of DB

ExtractJSON

Result

Let me know if this helps

[Anonymous]

Hi,

Thank you for your help, 

I tried your soluce but I have this error when I add these columns in tExtractJsonFields,

Thanks for your help

errorJob.PNG

[Anonymous]

It works finally, thank you very much !