Dynamic Column name

Thank you so much for your help, I appreciate it.  It is working but it is deleting all other data in the file see screen shots.  The other columns that have data, after running the transformation disappeared and only the column with the new data showing, and I know why, the other columns don't have data in the transformation so it overwrote what it is in the file with nothing .   I think we either just update that column with the data or somewhere read all the data from the file, calculate the new column data and just post everything to file, what do you think? I think I do the second option but not sure if I can just update one column in an excel file, can we?
 

>>> I think I do the second option but not sure if I can just update one column in an excel file, can we?

It is not possible at the moment but very easy option to add.

You said " I thing better option would be to add a check box to fields list called "Ignore nulls and keep original values"
(Not sure that it is correct name for i). 

Anyway if target cell has value and input value is not it will keep existing value in excel file"

You said you will have wok flow for this option.   Would really apprecite it - thank you 

Here is a new option

Please download and install the latest version and let us know the outcome

 

It is working nicely.  This is huge for this client - they have serveral Excel sheets that require this type of update ( a daily process) and they are doing them manually.   This will save them hours of manual work each month - You guys are the best - none one does what you guys do, no one.