Hi,
We have a Data Flow wherein the output is Json file and being sent to an FTP. However, we would like to know the steps how we can convert/transform a Json file into CSV output before we drop it to FTP. Please see the Data Flow setup below:
May we know how can we use the Scripting in order for the JSON file to be transformed into CSV file before sending it to FTP?
Please see sample JSON File from the MRM application that needs to be converted/transformed into CSV before sending to FTP