Order sort

Question

Dear All,
I am implementing a pipeline but I am taking more than enough snaps, my output is:

Desired output:

Is this possible using a single mapper snap?
Thanks in advance.

aleksandar_a · Answer

Hi @deepanshu.1,
I’ve managed to do this using only one Mapper snap, but in addition I used a Group By N Snap with the Group size set to 0 before the Mapper, and a JSON Splitter afterwards.
Here’s the expression:

And here’s the pipeline:
SampleWeatherAPIResponseMap_2022_02_28.slp (10.9 KB)
BR,
Aleksandar

marjan_karafilo · Answer

It should look like this:

I don’t know why the editor is replacing the symbol * and the quotation marks.
BR,
Marjan

marjan_karafilo · Answer

Hi @deepanshu.1 ,
Please try with the following in the mapper and let me know if it helps you:
$.group.map((x,index)=&gt; {“Location”:x.location, “Temp”:x.temp -273.15, “Temp_Order”:jsonPath($, “group[].temp").sort((a,b)=&gt;a-b).indexOf(x.temp)+1, “Press”:x.pressure, “Press_Order”:jsonPath($, "group[].pressure”).sort((a,b)=&gt;a-b).indexOf(x.pressure)+1, “Humidity”:x.humidity, “Humidity_Order”:jsonPath($, “group[*].humidity”).sort((a,b)=&gt;a-b).indexOf(x.humidity)+1})
BR,
Marjan

marjan_karafilo · Answer

Hi @deepanshu.1 ,
Please replace quotation marks “ and ” with " in the expression in mapper.
BR,
Marjan

aleksandar_a · Answer

Hi @deepanshu.1,
Also you can try to insert the asterisk symbol ‘*’ in between the marked square bracket on the picture below:

BR,
Aleksandar

Forum Discussion

Order sort

10 Replies

Recent Discussions

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?

Multipart Reader failure - 'content-type' was not found

Unable to write sldb file to file system