I have a CSV file that contains attributes for a start node and end node of a pipe in a single record. This is data collected in the field, so the inspector captures the lat/long at each end of the pipe, and then I load the CSV into QGIS to use other attribute data. I would like to find a way to automate/repeat creating a line layer that draws a feature from each start node attribute to the end node attribute for each record.
Here is an example of the data captured in the field. I would like to automate creating a single line from
"Location of inlet" to
"Location of outlet" for each record in the CSV.