We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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