Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Replacing Vlookup Formulas in excel

VijayAnaparthi
8 - Asteroid

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). 

1 REPLY 1
Felipe_Ribeir0
16 - Nebula

Hi @VijayAnaparthi 

 

One way of preserving the formatting of your output file is by configuring the output tool like this:

 

Felipe_Ribeir0_0-1671017001045.png

 

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.

 

Labels