DEV Community

Discussion on: CSV Challenge

Collapse
 
thorstenhirsch profile image
Thorsten Hirsch • Edited

Well, at work I would use a tool called "IBM Transformation Extender", which is specialised on data transformation. It breaks the job down into 3 tasks:

  1. create the csv output format (there's a gui for that)
  2. import some example json data in order to create the input format
  3. develop the "map" by configuring 1 as output, 2 as input, and the following "mapping rule" for the transformation:
=f_record(EXTRACT(Record:json, PRESENT(creditcard:.:json)))

...and in f_record() one would simply drag'n'drop the name and the credit card fields from the input to the output.

Not the cheapest solution, obviously, but its maintainability is great if you have hundreds of these mappings.