โ04-12-2022 05:41 AM
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!
Solved! Go to Solution.
โ04-12-2022 06:14 AM
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
โ04-12-2022 06:14 AM
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
โ04-13-2022 01:11 AM
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!
โ04-13-2022 01:53 AM
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
โ04-13-2022 05:00 AM
i tried json splitter but I am not sure of the json path for both id and header.