How to compare values from two tables in format control
How to compare values from two tables in format control.
Outage start in probsummary and Problem resolution date.
I think that of course the question about how to get the value from another table to compare the value of the current table.
You can check this in FC for probsummary.
In Queries tab you set other table and in Validation tab - use them by referring to the above tables in the Queries tab, in the order listed (file1, file2,...)
You can refer to the the target file\table from Query tab of the format control and then use the returned value based of the index of the query which will be resulting in the $filex variable. for example third query in the kist will keep the record in the $file3 .