Format an entire field based on field description in metadata

My goal is to format certain columns in an excel output generated by reporting tools. It needs to be dynamic because the number of columns in the ouptut can vary depending on in the input file. Ideally, I want to embed the criterion as metadata. For example, if a column is tagged "Formatted" in the description, the entire column should be highlighted in yellow. Alternatively, the criterion can be a row in the output.

Please let me know if this is possible in Alteryx or if there are any workarounds?

Thank you.

Reporting

Accepted answers

KimLamNg

Thanks everyone. I was able to solve the problem thanks to this post https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Highlight-cells-that-No-across-whole-workbook/td-p/643692

Essentially the idea is to use a batch macro to dynamically update the xml configuration of Table tool.

All comments

apathetichell

Hey --- there are some online trainings on how to use the table tool (and subsequently the render tool) in the online training. That can guide you in how to do this. So the short is --- yes. if you use the Table tool and Render. That means 1) you can only create the file one time in the worklow (one Render, all sheets) --- the tool will overwrite any existing any file with the same name.

Qiu

@KimLamNg
It is better to have a sample input and desired output for us to better understand your question.

caltang

Sounds like something the Reporting tool can do. What do you have in mind? Give us some data to work with and an expected output... then we can better advise.

KimLamNg

Thanks everyone. I was able to solve the problem thanks to this post https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Highlight-cells-that-No-across-whole-workbook/td-p/643692

Essentially the idea is to use a batch macro to dynamically update the xml configuration of Table tool.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703