Optimizing Data Extraction : Merging Complementary Lines

[stephbzr]

Hello,

Here is a simplified excerpt of the data I extract from a file.

There are two types of lines for each ID. The data retrieved from these two types complements each other, meaning that the data from the 'PM' line fills in the null data from the 'PA' line, and vice versa. In order to retain only one line, I would like to merge these two lines to streamline the process afterwards.

To extract this data, I'm working with a tFileInputDelimited component, followed by a tJavaFlex component. I'm correctly extracting these two lines, but I'm unsure how to proceed afterward.

Thank you

[Anonymous]

Hi

What are your expected output? line type will be included in the output?

Regards

Shong