Forum Discussion

Sahil's avatar
Sahil
Contributor
4 years ago
Solved

Map XML attribute to a field

Hi,
I need to map “id” and “header” field in mapper.
Data.txt (785 Bytes)

I am using file reader snap,xml parser and mapper.
in mapper, tried different expressions but not able to get the fields.
File is attached, Any suggestions!

  • Hi @Sahil ,

    With this expression in mapper, you can get the IDs:

    With this expression in mapper, you can get the Headers:

    Let me know if this helps you.

    BR,
    Marjan

4 Replies

  • Hi @Sahil ,

    With this expression in mapper, you can get the IDs:

    With this expression in mapper, you can get the Headers:

    Let me know if this helps you.

    BR,
    Marjan

    • Sahil's avatar
      Sahil
      Contributor

      I am getting Array of ‘id’ and ‘header’. I need this to join with another set of array containing ‘id’. How do I do that? thanks!

      • marjan_karafilo's avatar
        marjan_karafilo
        Contributor

        Hi @Sahil ,

        You can use JSON Splitter in order to split the array and then perform a Join with the other array.

        Also, it is recommended to use the Sort snap before joining the data.

        BR,
        Marjan