Hi All,
I have a requirement. in my source file i have diff columns like below
SITE LIMIT 1 CONDITION
SITE LIMIT 1 VALUE
AGGR LIMIT 1 CONDITION
AGGR LIMIT 1 VALUE
here i have concatenated site and Agg value and condition
"SITE LIMIT 1 CONDITION" & "SITE LIMIT 1 VALUE" as Site_Red,
"AGGR LIMIT 1 CONDITION" & "AGGR LIMIT 1 VALUE" as Agg_Red,
but my actual req is i have below data
| ID | Code | SITE LIMIT 1 CONDITION | SITE LIMIT 1 VALUE | AGGR LIMIT 1 CONDITION | AGGR LIMIT 1 VALUE |
| 5013 | W1 | > | 0 | > | 0 |
| 5009 | W2 | > | 50 | < | 0.8 |
| 5016 | W3 | > | 10 | < | 0.8 |
| 5015 | W4 | > | 95 | < | 0.8 |
| 5013 | W1 | < | 10 | > | 5 |
| 5013 | W1 | >= | 10 | > | 15 |
| 5009 | W2 | > | 0 | < | 0.8 |
here i want to display Color based on ID here i want to display color as Red for Site_Red & Agg_Red columns.
if it is single value it should display site_red if is multiple values it should display Agg_red based on ID.
Pls help on this
stalwar1
reddys310
Thnaks in Advance.
