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 fie...
pipeline
  • aditya_gupta41's avatar
    aditya_gupta41
    2 years ago

    Solution:

    I first used group by snap to group userID fields. Next I put a mapper and added a custom encrypted value with expression

    'XXXX'+sl.range(4).map(x => "0123456&#X"[Math.round(Math.random()*9)]).join('')

     Then I added a JSON splitter to split the group and included value of custom encryption.

marjan_karafilo's avatar
marjan_karafilo
Contributor
4 years ago
Copy LinkReport

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
    4 years ago
    Copy LinkReport

    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
      4 years ago
      Copy LinkReport

      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

      • Sahil's avatar
        Sahil
        Contributor
        4 years ago
        Copy LinkReport

        i tried json splitter but I am not sure of the json path for both id and header.