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
> >
>
