WellRJ Absent Member.
Absent Member.
298 views

How to compare values from two tables in format control

How to compare values from two tables in format control.

Example:

Outage start in probsummary and Problem resolution date.

 

Thank you!

 

 

0 Likes
3 Replies
Established Member.. MickeyMi
Established Member..

Re: How to compare values from two tables in format control

You don't know how to compare or dont' know how to retreive the value ?

0 Likes
ALARMus Acclaimed Contributor.
Acclaimed Contributor.

Re: How to compare values from two tables in format control

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,...)

0 Likes
Acclaimed Contributor.. Vadim Gorda Acclaimed Contributor..
Acclaimed Contributor..

Re: How to compare values from two tables in format control

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 .

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.