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

[nikorc]

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

[to4kawa]

`INGEST_EVAL` makes new fields and existed fileds null.

[nikorc]

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