Set Output Options of Output Data tool dynamically

Hi Alteryx engineer, is there a way I can pass a value to update the Output Options value of Output Data tool dynamically ?

Suppose I pass "Append To Existing Sheet" or "Overwrite Sheet or Range" so it can be set to the Output Options and perform corresponding operation

Help

Accepted answers

Sebastiaandb

@187 ,

I also saved them as 2021.3 instead of 2022.1 (couldn't package them tough as default packaging would be in 2022.1 and it wouldn't let me edit it in Notepad++).

Greetings,

Seb

testworkflow.yxmd

test update.yxmc

All comments

Sebastiaandb

@187 ,

I guess you can, i tried a bit with the action tool and you seem to be able to change the parameter in the output data tool by making it a macro.

In my example, i used a drop down tool to alter the action tool but you can use different scenarios for it as well.

Hope it helps,

Greetings,

Seb

187

@Sebastiaandb

Thanks Seb for the quick reply, I will try with it thanks!

Sebastiaandb

@187 No problem!

In case you have specifically figured out how you want to feed the action tool and are not able to fix it yourself, let me know and i can see if i can help :-)

Greetings,

Seb

grazitti_sapna

@187 , you will have to create an Alteryx app with dropdown option to select from the various options. Please find my solution workflow attached to the post. Let me know if it was helpful.

LT_workflow.yxwz

187

@grazitti_sapna

sorry I can't open your workflow due to older version i am using, can you and @Sebastiaandb help look at my thought and point out why it doesn't work? My idea is to check if a file path contains $ sign, i will update the method to Overwrite, if not, stick to the original Append then

test update.yxzp

Sebastiaandb

Hi @187 ,

I'll have a better look at it but in a quick glance i guess here's the problem.

Change Overwrite in the red cirkel to Append. The tool is set to append but you ask the action tool to replace Overwrite but overwrite doesnt exist :-).

I tried this:

Greetings,

Seb

Sebastiaandb

@187 ,

Here you go!

This should work :-)

If you change the File Path value to without $, it appends, with $ it overwrites :-)

Greetings,

Seb

testworkflow.yxzp

Sebastiaandb

@187 ,

I also saved them as 2021.3 instead of 2022.1 (couldn't package them tough as default packaging would be in 2022.1 and it wouldn't let me edit it in Notepad++).

Greetings,

Seb

Thanks Seb for explains the theory of action tool, I got that point and appreciate so much for helping. This works as expected!! Have a good day.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703