Set Output Options of Output Data tool dynamically

[187]

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

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

[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

[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

[Sebastiaandb · Accepted solution]

@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

[187]

@Sebastiaandb 

 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.