A, If this were the input data:
Store,Date,Weekly_Sales,Holiday_Flag,Temperature,Fuel_Price,CPI,Unemployment 1,05-02-2010,1643690.9,0,42.31,2.572,211.0963582,8.106 1,12-02-2010,1641957.44,1,38.51,2.548,211.2421698,8.106 1,19-02-2010,1611968.17,0,39.93,2.514,211.2891429,8.106 1,26-02-2010,1409727.59,0,46.63,2.561,211.3196429,8.106 I would want the first record (csv line) to be converted to something that looked like: { "entity" : [ { "Name" : "store", "Value" : 1 }, { "Name" : "date", "Value" : "05-02-2010" }, { "Name" : "weekly_sales", "Value" : 1643690.9 } .....<rest of the line>.... ] } and each subsequent record to be handled in a similar way. Looking at the jolt-demo (mentioned above), this seems to be similar to the map-to-list behavior. mew On 2023/09/18 20:19:40 Pierre Villard wrote: > Hi, > > Do you have an example of input and the output you'd expect? There are a > few options in terms of processors you could use and you may be able to get > things working the way you want without using JOLT. > > Pierre > > Le lun. 18 sept. 2023 à 22:05, Mark Woodcock <wo...@usna.edu.invalid> a > écrit : > > > Howdy, > > > > What I'm aiming for: > > Something that takes a fairly ordinary record (think a CSV file--so, the > > name of each column is a distinct entry in the schema), which outputs the > > same data, but where the record is now an array of similarly structured > > items (I presume records, where the fields would be stuff like a columnName > > [where the value is CSV column name], value [where the value is the value], > > and perhaps other fields). > > > > When I asked around, the suggestion was that my need was to flatten the > > schema and that the JOLT processor might be the way to do that...but my > > contact had never used JOLT. The follow-on suggestion was to ask here > > (well, on "users" but that rejected me, since this address worked before, > > I'm trying it) for advice on how one might go about that. > > > > thx, > > > > mew > > >