filter and transform json

Anonymous — Sat, 25 Aug 2018 15:34:42 GMT

i'm looking for recommendation for a simple usecase of filtering and transformation of JSON stream

basically i have an stream of JSON or an array. all item of same flat schema (each JSON representing a RDBMS row of a table) I need to : 1) filter out some keys (aka column) 2) transform some values (like replace key words with other in the value par of JSON KV pair 3) modify the K like all lower case it.

I tumble upon, JOLT in the context of a Apache NiFi flow I'm failing to find how to do 3 the key renaming.

on Jolt site, alternative are gracefully pointed to like JsonSurfer and others. Given the use case above, what tool chain would you recommend. It has to be scalable or workable in a stream like fashion (JsonSurfer looks interesting on that end). Also, It'd be great if solution can be included in either Nifi or Talend, unless these tools already have a solution that i don't know of

Re: filter and transform json

Anonymous — Tue, 04 Sep 2018 08:41:32 GMT

Hello,

Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina

topic filter and transform json in Data Quality

filter and transform json

Re: filter and transform json