In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Dynamic color coding with more than 100+ columns

faisal9999
8 - Asteroid

I have small data attached this is just sample with date, and string columns ABC....I have 100+ column, Now I want to do color coding on each and every cell if any cell = 0 then Green and else Red. 

I have tried on Basic Table but as I have more than 100 column so can not apply formula on 100 columns as it will time.

 

please help if you can. thanks

1 REPLY 1
griffinwelsh
12 - Quasar

@faisal9999

1.drop a table tool onto your canvas but do not connect the input anchor

2.create your column rules for Dynamic or Unknown Fields. Use formula [_CurrentField_] = 0 for your green color and [_CurrentField_] != 0 for your red color

3.connect your input and the dynamic rules will apply to all columns

2084.png

Labels
Top Solution Authors