Customer Portal

Howto read a yaml file

Comments 1

  • Avatar
    slechtaj
    0
    Comment actions Permalink
    Hi Stephan,

    If the yaml file structure looks always like this, you may use Pivot component instead of configuring ComplexDataReader. The process might look like this:

    • Read rows from the YAML file one by one using UniversalDataReader

    • Trim the strings (since the file contains a lot of white spaces that you might not want to map into fields).

    • Using Pivot component transpose the input records into fields in metadata of the output record. (see the attached example)

    Of course if the YAML file was more structured etc. it might need to be done another way, but for the mentioned structure this is sufficient.

    Hope it helps.

Please sign in to leave a comment.