CSV field header/label based on a value in column.

nikorc — Mon, 10 Aug 2020 20:49:04 GMT

So I have a csv file that is generated while a program runs. The 1st 4 columns are same headers. DATE,TIME, LOCATION,EVENT. After this there can be 4-8 more fields with unique headers on what the event field is equal to.

For example if the event = 1 then the field and headers would be. DATE,TIME, LOCATION,EVENT,speed,tilt

For example if the event = 2 then the field and headers would be. DATE,TIME, LOCATION,EVENT,altitude,latitude,longitude.

I am not fully sure how to get this data in with the proper field headers.

example:
2020/03/03,13:40:23,Ohio,1,200,30
2020/03/03,13:40:23,Ohio,2,33000,40.4173,82.9071

Re: CSV field header/label based on a value in column.

to4kawa — Tue, 11 Aug 2020 00:33:39 GMT

`INGEST_EVAL` makes new fields and existed fileds null.

Re: CSV field header/label based on a value in column.

nikorc — Tue, 11 Aug 2020 17:34:32 GMT

Thank you so much! This is exactly what I was looking for.

topic Re: CSV field header/label based on a value in column. in Getting Data In

CSV field header/label based on a value in column.

Re: CSV field header/label based on a value in column.

Re: CSV field header/label based on a value in column.