I possess EHR data which contains nested JSON format. I would like to extract all the fields and convert them into a CSV file. How can I achieve this in Sparkflows?

[Tarika]

You can use the Flatten and Explode nodes. The “Flatten” node allows to convert complex nested structures into a more straightforward columnar format. On the other hand, the “Explode” node is useful for breaking down arrays or expanding a column with nested structures into multiple rows, facilitating further analysis or processing of the data. By utilizing these nodes, you can effectively handle and extract valuable information from complex data structures.

For more detailed information read Sparkflows documentation here:

Flatten - Data Preparation: Miscellaneous — Sparkflows 3.0 documentation

Explode - Data Preparation: Miscellaneous — Sparkflows 3.0 documentation