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:
create the csv output format (there's a gui for that)
import some example json data in order to create the input format
develop the "map" by configuring 1 as output, 2 as input, and the following "mapping rule" for the transformation:
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:
...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.