Need to change the output from Kafka

[gouravd_7]

Hi Team,

I have created one job for Kafka and am almost there with the output.

However the output which am getting is like below 

{"deviceId":"5mrnxdgghlkfbv35nj97oean3","source":"tcp://10.154.104.124:1883","timestamp":1543245224848,"format":"json","content":"{\"success\": true, \"datatype\": \"REAL\", \"timestamp\": 1543245225818, \"registerId\": \"EACDBFE6-A93D-491E-8BB4-0D29E0BDEF78\", \"value\": 740.0, \"deviceID\": \"A49C29D6-016C-4361-9EF1-EA6363039C3F\", \"tagName\": \"LKT2_Four_S6D_Csg_Temp\"}"}

And the expected output should be 

5mrnxdgghlkfbv35nj97oean3|tcp://10.154.104.124:1883|1543245224848|json|true|REAL|1543245225818|EACDBFE6-A93D-491E-8BB4-0D29E0BDEF78|740.0|A49C29D6-016C-4361-9EF1-EA6363039C3F|LKT2_Four_S6D_Csg_Temp

Requesting you to please help me with settings need to do to get the desired output.

I am attaching Job snapshot and component.

Thanks & Regards,

Gourav Dubey

[Anonymous]

Hi Gourav,

       The data is currently in JSON format and you will have extract the data to other format using tExtractJSONFields component.

Please refer the below link for sample job.

https://help.talend.com/reader/NNO~fmVQU4rlkF9Depfdxw/pE_VAoC_7gi4DWQ02Y89oA

If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi