Below is the sample format of the JSON input from Kafka,we have 100+ columns are there and want to convert to a row. Have used tExtracJsonfield transformation using JSON path, am getting below is the actual output
Input from Kafka : { "ACTION":{"string":"U"}, "RESTART":{"string":"1AX7GpFUZwAAAAAAAAX7GpFUVQAAAAcAAGGxAB39GgDoAAEAAAAAAAEAAAAA"}, "FLG":{"string":"Y"} }
Actual Result: "string":"U" | "string":"1AX7GpFUZwAAAAAAAAX7GpFUVQAAAAcAAGGxAB39GgDoAAEAAAAAAAEAAAAA" | "string":"Y"
Expected Result: U | 1AX7GpFUZwAAAAAAAAX7GpFUVQAAAAcAAGGxAB39GgDoAAEAAAAAAAEAAAAA | Y
How to escape the data type and Double quote value in the tExtractjson field transformation? Please advise.
