I workflow where I need to update single columns in a large spreasheet with formulas in most columns. I will need to reference the column using the column header (1st row).
How do I achieve this with Alteryx?
Hi,
Can you expand on what exactly you're trying to achieve? Generally when you use an Excel file as input to Alteryx, the columns contain the data values only. Similarly, when you write back the formulas will be overwritten. You may be able to overcome this by writing back to CSV - see https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Writing-Formulas-to-Excel/ta-p/12337 by @MattD.
Cheers,
Iain
@ivoller,
Essentially what I need to do is at the end of the workflow, I need to update data certain columns in an existing spreadsheet. I don't want to overwrite the spreadsheet.
