Property table box

[carlosban]

Property table box

Good, I require the text to be RED (Inoperative) and BLUE (Operative)

Thank you.

[balabhaskarqlik]

By Using of Table box, Mostly you won't able to get Text color change based on value. You better use Straight table to achieve this.

Or try like this:

You can achieve the same by adding all fields as dimensions, adding one expression, hiding that expression. Then use a formula to set the color. You can use a script:

Load *, Evaluate(Color & '()') as Color2;

LOAD * INLINE

[

    Color, Text

    Green, ABC

    Blue, DEF

    Yellow, GHI

];

Use the Color2 field in your dimension / expression background or text color, as is, to set the color.