Forum Discussion

Henchway's avatar
Henchway
Contributor
5 years ago

"Sort path" based on dynamic columns // sort & diff

Hi, i’m having the following challenge: I’m pulling data from a REST API as well as SQL tables. Before grabbing the actual objects, i’m grabbing “Object Types” from the REST API to know which t...
Supratim's avatar
Supratim
Contributor III
5 years ago
Copy LinkReport

@Henchway As there are some limitation to use expression in diff snap, one work around I can think about (even though it’s might not very good approach), use Router based on the object type then add the relevant key for every diff snap. It might help you to avoid creating 6 different pipeline. 🙂

  • Supratim's avatar
    Supratim
    Contributor III
    5 years ago
    Copy LinkReport

    @Harsha3 - Try below approach-
    Use group by N make it as 0 so all record should be grp by in one array, then change the table data path with your group name like below-

    • Harsha3's avatar
      Harsha3
      New Contributor III
      5 years ago
      Copy LinkReport

      Hi Supratim,

      Thanks for the reply I have tried that approach still we get two rows instead of one for having two values.

      Thanks,
      Harshavardhana

      • del's avatar
        del
        Contributor III
        5 years ago
        Copy LinkReport

        @Harsha3,
        You might try the Aggregate snap using the MAX function:

    • Harsha3's avatar
      Harsha3
      New Contributor III
      5 years ago
      Copy LinkReport

      Hi Alchemiz,

      I was able to obtain the result as per your method . Thanks since I am new to IT with intermediate knowledge in snaplogic , I would like to know how to create a vertical table . Can you please help me in modifying the code which I published below ( This code creates horizontal table).

      Email Snap HTML Table table.Snap {background-color:transparent;border-collapse:collapse;width:100%;} table.Snap th, table.Snap td {text-align:center;border:1px solid black;padding:5px;} table.Snap th {background-color:Aquamarine;}

      Hi Team,

      Kindly find the attached sheet which contains affiliation and address mismatches in SIQ.

      Success and Error record count:

      Regards,