Apply Formula CSV or Tables: On or Including Header Row
Options
Jacob_154284
Posts: 75
in Ideas
It would be helpful to apply a formula on the header row either independently or within the Tables/CSV Apply Formula actions.
I had a use case where I uploaded an excel file, converted it to a data table, and then tried to apply formulas on it. The formulas worked to remove white spaces from the rows with data but my header columns still had white spaces which threw off other parts of my process. I'm guessing I could reference the columns["field-name"] instead of the columns['Display Name'] but being able to clean up the header row would be great if you know you want to remove quotes, commas, etc... before performing the next steps on the data table or csv file.
Tagged:
0