We sometimes receive a header file that is separate from the data file. The header file contains one row of field names that correspond to the sequence that the data is sent in. How can I read both the header file and data file in and have it combine into one before creating metadata?
I hope that makes sense. Thanks!
Hi,
I would recommend using a Jobflow with two ExecuteGraphs (one for the creation of the metadata, and one to extract the data based on it) to accomplish your use case. I have taken the liberty of creating a example of this based on the data you sent me. The following is whats included in the zip folder:
metadata_writer.grf - Will create dynamic metadata based on any header file using the XMLWriter and saving it to a predefined Parameter value, which you can read more about here(from the data in your header file, I would recommend that you set the max number of records property to 1
flatfile.grf - Will extract the data using the dynamic metadata
metadata.jbf - Will have both ExecuteGraphs (you only need to run the Jobflow)