Is there any way to modify column headers in an external CSV file?

Mitch Dale

Hey @Product

I have a use case where a CSV file will be inputted into a WF, and the WF will need to check the column headers for any typos, and if any are found, correct the column header(s). In this use case, the CSV file will end up being fed into another system, hence I need to end up with a CSV file. And the files will be quite large so importing into Google Drive as a GSheet, and making the updates there isn't ideal.

Is there any way to modify a column header in an CSV file? One idea I had is to query the entire CSV as JSON (i.e. select * from CSV) and use aliases to correct the column headers (i.e. select mistypedHeader as properHeader), and then convert the resulting JSON body into a CSV - I feel like that could work, but I'm just curious if there's a simpler way.

Thank you

Dylan

Mitch Dale I think the approach you suggested is probably going to be the best way to handle this.

Using the Query CSV using SQL Wrk Action, you can use SELECT and AS statements to rename the incoming columns to the expected column headers. For example:

SELECT FirstName AS "First Name", Bday AS "Birthday"

The action also has a CSV output, so there shouldn’t be any need to convert the query result from JSON back into CSV afterward. You should be able to perform the column header transformation in the SQL query and then use the resulting CSV file directly in the downstream workflow.