Forum Discussion

ionutbarna's avatar
ionutbarna
New Contributor II
4 years ago

Flatten multilevel/nested JSON Objects and Arrays

Hello there, Is there a way to flatten a nested JSON (multiple objects inside objects/arrays) without using a Script Snap? Take this input for example: { "msg":"Hello, World", "num":1, ...
expression_language
pipeline
transform
  • hemangjalali's avatar
    hemangjalali
    New Contributor II
    2 years ago

    Wow! That's a powerful snap! Worked like a charm for my use case.
    Thank you for the suggestion.

    • Michael's avatar
      Michael
      Employee
      2 years ago

      Indeed it is! This snap can flatten structures, split columns, mask data, rename columns, handle nulls, and more, much faster than relying on python or expressions.