Macro to adjust the settings for all table tools within a workflow

Hi everyone!
I need to create a macro that when dropped to a workflow will adjust all table settings within that workflow to the same one (that is not a default one). Could someone give me an idea how to build such macro as I am not getting enough information online to build one and I do not have enough experience with macros 😞

Thank you!
Natalia

Macros

Accepted answers

All comments

danilang

Hi @nataliad18

Unlike Excel, where you can write a junk of VBA in a macro and have it do almost anything to the spreadsheet that its contained in, Alteryx macros are a grouping of tools that perform some data modification related purpose. Alteryx macros can't change any properties of the tools contained in the workflow that the macro is included in.

While it would be possible to make a separate workflow that opens a generic workflow as an html file and changes all the table settings, and writes it back out as a yxmd file, you can't reproduce the same functionality in a macro.

Dan

nataliad18

Hi Dan!

Thanks for the reply!

Would it not be possible to have the macro then linked to each table tool in order for it to "action" it and set the parameters in the table tool to whatever the macro says it should be?

Nanoq

hey nataliad
do you want to have the same output schema for all tables, regardless of what the input looked like?
As i understand it, you want a macro that changes the layout of a file to some fixed system?

nataliad18

hey Nanoq,

I want the colours and the formatting to match, yes. As far as I understand, I should be able to link the table tool to the macro and then the table will have different settings instead of the "default" settings (the data, header, borders, table text colour, background colour and alternate colour"

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703