CSV file from google drive change header

How To
1

So this seems doable but i cant figure it out. I have a csv file in google drive, with a filename of ADT. in that file is a column header name of Inventory Available:
what im trying to acheive is open the csv, parse it, and then add the file name of ADT onto the header name so that it ends up as

Inventory Available: ADT

i know i can manually set this, but i have 100 different files each day with diff file names that all need the same treatment

thanks

2

Hi @Erin_Bond,

I’m not quite sure what you’re trying to achieve. Do you want to re-name the file itself or a specific value in the CSV?

Best,
Richard