How to replace vlookup Formulas that are already there in Excel file with blank in Alteryx and store the blank to same Excel file.
Here main thing is that i am using preserving format in output tool. So i can't use overwrite file(Remove).
One way of preserving the formatting of your output file is by configuring the output tool like this:
The only thing is that you goona need to provide the range to write your output (like from cell A1 to cell A7). Take a look at the attached workflow.