We have a requirement which i need to clarify here where in put an example which states our requirement . Kindly suggest which would be the better approach to follow.
We have a column 1 in Table A which shows a value X ,and we have a column 1 in the Table B which shows value Y and also we have column 2 in Table B . Now the comparison is the value X of Table A should look on to Value Y of Table B and decide whether Red Image / Green Image / Yellow Image to be represented in the Column 2 of Table B based on a condition.
Kindly suggest how can i approach in this scenario.
In table B, in your color expression, you want to reference a value in table A? The specifics of how to solve it depend heavily on the specifics of your two tables, but basically, in B's color expression, you'll need to recreate table A. Maybe that's just repeating an expression from A if, say, the dimensions are the same. Maybe that's an aggr() expression of some sort if they aren't.
