Forum Discussion

Henchway's avatar
Henchway
Contributor
6 years ago
Solved

Value to Field Mapping

Hi everyone, I’ve been trying to find a function that would allow a “Value to field” mapping such as this: As depicted, i would like to use Values as Keys in order to use them in expression ...
  • dimitri_hristov's avatar
    dimitri_hristov
    6 years ago

    Hi @Henchway,
    In this post, I have attached a pipeline that can demonstrate my solution to your question.
    In the first JSON Generator Snap I generate the test data according to your problem statement.
    Then I use a Group By N Snap to generate input for the final snap in a usable format.
    Lastly, in the final snap, a JSON Generator, I use Apache Velocity to output the data in the desired format.
    Please have a look at the pipeline, and I’ll be happy to answer any further questions you may have.
    BR,
    Dimitri

    ValueToFieldMapping_2020_03_23.slp (4.5 KB)

dimitri_hristov's avatar
dimitri_hristov
Contributor
6 years ago

Hi @Henchway,
In this post, I have attached a pipeline that can demonstrate my solution to your question.
In the first JSON Generator Snap I generate the test data according to your problem statement.
Then I use a Group By N Snap to generate input for the final snap in a usable format.
Lastly, in the final snap, a JSON Generator, I use Apache Velocity to output the data in the desired format.
Please have a look at the pipeline, and I’ll be happy to answer any further questions you may have.
BR,
Dimitri

ValueToFieldMapping_2020_03_23.slp (4.5 KB)

Vinod_Yadav's avatar
Vinod_Yadav
New Contributor
5 years ago

Perfect! I like your solution.