FOCUS Fridays VUG - MATCH - the Other JOIN, FML Hierarchy, and Stack Searching, Sorting and Unique values

FOCUS Fridays continues its exploration of the FOCUS/WebFOCUS language this month by covering the uses of the other file connection command - MATCH FILE, the FML Hierarchy extension that simplifies hierarchical reporting, and the use of the Stack in MAINTAIN for searching and sorting.

MATCH - the other JOIN
JOIN is the primary universal syntax that allows us to connect the data in two files. FOCUS/WebFOCUS also supports the MATCH syntax which allows the connection and merging of data in multiple files. In this session we will cover some of the uses of this command.

FML Hierarchy
This session will extend your knowledge of the financial reporting language by delving into the hierarchical reporting capabilities that are available.

Stack Searching, Sorting and Unique values
Stacks are used to collect and display data. This presentation focuses on case insensitive searching, sorting and removing duplicate values from the stack before display.

FOCUS Fridays VUG - MATCH - the Other JOIN, FML Hierarchy, and Stack Searching, Sorting and Unique values-20220715-finalcut
You may also be interested in:

Success with TIBCO:

FIRST

casino in Las Vegas to go live with cloud-based hotel management

50,000/CAR/SECOND

Thousands of data points per car, per second understood with TIBCO Spotfire

BEST

Airport in Europe, 4 years in a row (Airports Council International)

$300K SAVINGS/MONTH

In electricity consumption via analytic-driven asset utilization

Watch Webinar