[FEATURE] : Ability to Transform Header

[sharathchandramg]

I am looking at feature of transforming only the header data of my CSV file. The data import CSV files generally have human readable names, and its easier for processing if I can remap to internal names

I am currently looking at using mapKeys from lodash to transform the keys. However this needs to run for every entry.

csv
                .parseFile(req["file"].path, { headers: true, trim: true, ignoreEmpty: true, discardUnmappedColumns: true, strictColumnHandling: true })
                .on('data', row => { })
                .transform((d) => {
                    const data = formDataServiceManager.mapKeysFromDisplayToInternal(d);
                    
                })
                .on("data-invalid", (row, rowNumber) => { /*console.log("invalid")*/ })
                .on("end", (rowCount) => { return console.log("Here ") });

The renaming of headers won't work since users can change the order of the columns before uploading the data.

[doug-martin]

Released in v3.7.0