reading csv file with layout defined in json file

Question

Hi All,

I am trying to resolve the following issue. I have input data as .csv file and I’ve format of the file defined in .json file. Is it possible to read the csv file with layout being picked from json file? I looked around but couldn’t find an example on how to do that.

Thanks,

--Ramesh

apathetichell · Answer

when you say layout - do you mean Field Names? If so you'll use dynamic rename with the json column of field names going into your right/lower anchor and the .csv input going into your left anchor.

dougperez · Answer

Can you provide some mock data ?

You will have to read those both files separately then union to apply the format (and use a dynamic rename to put the name of the fields).