Forum Discussion

SL12345's avatar
SL12345
New Contributor III
3 years ago
Solved

Create hierarchical Json from mapper output

Hello Snaplogic experts, is it possible from input [ { "Manufacturer": "BMW" "type": "M3" "Fuel": "petrol" } { "Manufacturer": "BMW" "type": "M5" "Fuel": "petrol" } { "Manufacturer": "Mercedel" ...
  • Aleksandar_A's avatar
    Aleksandar_A
    12 months ago

    Hello lake,

    Attached is the sample pipeline for structuring the data as needed:

    1. Split the ndc array.
    2. Sort and group by num, lotNum, and expDate.
    3. Consolidate serialNumber.
    4. Reassemble the ndc array.

    Let me know if you have any questions.

    Best regards,

    Aleksandar.

Aleksandar_A's avatar
Aleksandar_A
Contributor III
3 years ago
Copy Link

Hi, can you please provide me the exact valid JSON?

SL12345's avatar
SL12345
New Contributor III
3 years ago
Copy Link

Hi, it looks like this:

[
        {
"Manufacturer": BMW
   "Infos":
        [
        {
        "type":"M3"
        "Fuel":"petrol"
        }
        ]
 "Manufacturer": BMW
   "Infos":
        [       
        {
        "type":"M5"
        "Fuel":"petrol"
        }
        ]
        }
        {
"Manufacturer": Mercedes
   "Infos":
        [
        {
        "type":"GLS"
        "Fuel":"diesel"
        }     
        ]
        }
]

i would like to group it/sort it under one Manufacturer

    • SL12345's avatar
      SL12345
      New Contributor III
      3 years ago
      Copy Link

      Thank you very much Aleksandar …thats what i was looking for