We are attempting to compare the string values from 2 different fields, and report on the values which are found in both fields.
Example:
Date,Field1,Field2,Foo,Bar
4.3.17,123456,ffgghh,sfuff,stuff
4.4.17,000000,123456,stuff,stuff
Report: value 123456 is found in field1 and field2
I have been able to build a table to show the values of the fields and visually find the matches, I need to be able to do this over large periods of time, and then build alerts when there is a value in Field1 which appears in Field2.
Thanks
... View more