Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Applying Column formatting rules to dynamic columns

Wrigley510
6 - Meteoroid

Hi,

 

I'm attempting to have the Table tool format certain values in a table when they hit a particular threshold. 

 

Some background- I am doing some 6-week forecast reporting and the column headers will be dynamically changing week-over-week. I have followed the instructions in the walkthrough below to get the Unknown/Dynamic formatting to apply to the data in each column, but I am getting the following error 'The field "*Unknown" is not found in the record' and the data is not being formatted. 

 

(https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Apply-Column-Rules-to-Multiple-Columns-in-th...)

 

Any help would be appreciated.

13 REPLIES 13
camarieschmidt
5 - Atom

Any update on solution? I am having the same issue.

Ramesh_Y1987
5 - Atom

Is there any update on solution for this, since i am encountering the same issue for my workflow

 

melissa_m
8 - Asteroid

Looking for a solution as well...

IntlTaxGuy16
7 - Meteor

Using the formula option as shown in the attached image worked for me. 

 

tonumber([_CurrentField_])<0

 

Labels
Top Solution Authors