New here just trying to learn. I have two columns I want to compare and change the color… So column 1 is a number and column 2 is also a number… What im trying to do is see if column 2 is greater than column 1 and if it is greater than column 1 then change the color. Im thinking this could be a value mapping with the color change but im not sure how to set the regex.
what is your data source
CSV files
the TB in the data, is that from Standard Options or is the raw data have TB
So the TB cloumn is just a number and the raw data is the Size column… So its basically the person is paying for TB and the Size column is the size of the folder. So if their TB is set to 2TB and they are listing 5.91TiB then they are over the amount they are set to and it needs to change colors and get looked at.
You could do a difference column (using an Add field from calculation transformation) and set the coloring based on that column. Disadvantage is that this column need to be visible, but I don’t know if that’s a big disadvantage.
1 Like
Do you think doing a value mapping regex that just says if column TBs < Size Column change color? I’ve tried looking at the regex expression but can’t wrap my head around how to set that up.
regex is for extracting data from data, not for doing calculations.
1 Like
wish this feature had a use but hide from display
1 Like
Do you have a example of how to use the field form calculation to do what I’m trying to do?
Value mappings can’t comapre fields unfortunately
So what would be the best option to say grater than? Because the Add Field from calculation doesn’t do that.
There is none I’m afraid. Just subtract one from another and look at the difference.
1 Like
Tu peux m’expliquer clairement ton probleme stp.