dynamic updating the excel

I have excel which is containing multiple formulas and filters and to which there is a last column "status" , when workflow run it will update a value in status column . usually it overwrites the entire excel which will kill the filters and formula instead of that i have added range now it fails as it throws error "unable to overwrite the cell contains formula ".

Workflow

Developer

Designer Cloud

Tips and Tricks

Transformation

Dynamic Processing

Join

Database Connection

Run Command

Accepted answers

trung2403

Hi @adarsh2608,

I have changed a bit. Actually you dont need to create a new field for file path. The idea is that you get the value for Status column, reorder it to make sure it in the same order of your original dataset (that why i had record ID tool at the beginning and Sort it by ascending order at the end). Then, only select the Status column to write to the output file in column I, starting from cell I2. Please refer to the Output configuration as below. You can notice that in the file name, i write down Sheet1$I1:I.

The final output will look like this:

The whole WF. (Sorry, I'm using company's laptop and not allowed to upload any file. So cannot attach the WF here. But if you still need it, do let me know, i will upload when i get back home)

All comments

hellyars

If all else fails, why not output from Alteryx to a separate sheet and have the Excel formula refer to it?

hellyars

Check to make sure your range is correct.

...does Alteryx output the Excel formula? If not, see if that works.

trung2403

Hi,

You should output to Status column only. For example, I will output Status value to column B starting from cell B3. The rest of the excel file will remain unchanged. By doing this, you will not overwrite those columns having embedded formulas. Please refer to the below for detailed configurations.

adarsh2608

Hello @trung2403 and @hellyars

I have attached excel and workflow and did same as mentioned, didn't work, can you help

New Workflow2_Autosave.yxmd

data.xlsx

Felipe_Ribeir0

Hi @adarsh2608

Please try again with the attached workflow.

New Workflow2_Autosave (1).yxmd

adarsh2608

Hello @Felipe_Ribeir0 ,

After running the workflow though it is getting updated but in the wrong column , i have filtered to update in last 2 month in the workflow it is showing correctly but in the excel it is not updating correctly.

Felipe_Ribeir0

Hi @adarsh2608

You want to update just the I column, right?

Try again please, i made one change

New Workflow2_Autosave (1).yxmd

trung2403

Hi @adarsh2608,

The final output will look like this:

The whole WF. (Sorry, I'm using company's laptop and not allowed to upload any file. So cannot attach the WF here. But if you still need it, do let me know, i will upload when i get back home)

adarsh2608

@trung2403 , this was helpful, thank you

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335