Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Mirlynn]

I would like to compare the values in InitialKey with those in the Grouping fields. Ideally I would like to find where the values do not match. I have looked at expressions but I don't know how I would go about doing a comparison between 2 fields and potentially updating one field or the other (ie update initialkey with the value in grouping or vice versa).

Any thoughts or direction on how to approach this would be tremendously appreciated.

[zybex]

Can you give some examples of the content of those fields and what you would like the final result to be?

[HPBEME]

Perhaps not as elegant as an expression, but this is an approach I use a fair amount when I want to compare to values, and it works quite well.

Activate a view where all files are shown in a detailed list. Add columns for Initial Key and Grouping, then click on either of the column headers to sort by that field. You can then easily see which fields do not match in the unsorted column. You can use search wizard to set various rules/modifiers to further limit the number of files shown (e.g., a rule to exclude files with empty values for either of those fields).