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