HDL transformation formula - How to process multiple lines together

Summary:

Hi All,

Can anyone suggest how to process multiple lines together in an HDL Transformation Fast Formula?

I have a fixed-length data file where each person can have multiple lines based on different criteria. One line contains details for certain element entry values, while another line contains information for the remaining element entry values.

For example, in the file below, for the same person (e.g., ****-XX-XXXX):

• Line 1 contains information for the input value "Amount"
• Line 2 contains information for the input value "Total Owed"

Both element entry values should be created with the same Effective Start Date, which is available only in the