Forum Discussion

darshthakkar's avatar
darshthakkar
Valued Contributor
3 years ago
Solved

Converting value of input schema to distinct columns

Hi Team, I’m reading a text file and wanted to fetch DISTINCT columns out of the data itself, screenshot below for your reference. .txt file: When I read the above data in snaplogic, the f...
expression_language
transform
  • tstack's avatar
    tstack
    6 years ago

    They are null because the second object in the group has null values for those properties, so it is overwriting the values from the first object in the group.

    I would suggest moving Mapper2 in your example to the end of the pipeline and just work with the objects you already have. You can then use the merge() method to combine the objects in the group together. The merge will preserve the nested structure, so that the values of one object in the group don’t clobber the values in the other objects.

    Here’s an updated version of your example:

    GroupingObjects_2019_10_22.slp (28.2 KB)

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

Hello @manohar,

The following expression should do the job:

sl.range(0, $quantity.length).map( x => $.mapValues(v => x < v.length ? v[x] : ""))

Let me know if this helps you.

BR,
Aleksandar.

  • bojanvelevski's avatar
    bojanvelevski
    Valued Contributor
    3 years ago
    Copy LinkReport

    Hi @KTsnap,

    I believe this expression will do the job:

    $group.map((x,index)=>$['@id'] == index + 1 ? (x.mapValues((v,k)=> $col.find(e => e['@id']-1 == x.keys().indexOf(k)) != null ? $col.find(e => e['@id']-1 == x.keys().indexOf(k) ).get('$') : v)) : x)

    It’s rather complex, so I would suggest you to do some testing.

    Regards,
    Bojan

    • rashmi's avatar
      rashmi
      New Contributor III
      3 years ago
      Copy LinkReport

      Hi @bojanvelevski similarly if i have two array called row and group as shown below



      I need to replace the the value of second array ie group array with values from first array ie row array
      to elaborate->row id in first array (row array) is corresponding to first record in second array(group array) and colid in first array(row array) is corresponding to A, B, C,D,E,F,G,H,I in the second array(group array).Example:first record of second array(group array) with values corresponding to column B and C must be updated with value ($) corresponding to first array(row array) with row id 1 and col id is 2 &col id is 3but remaining column values like A,D,E,F…I values should remain as incoming input values

      Expected output is as shown below

      Please could u help telling how can we achieve this using mapper expression here

      • bojanvelevski's avatar
        bojanvelevski
        Valued Contributor
        3 years ago
        Copy LinkReport

        If my understanding is correct, this is the same situation, isn’t it ?

        You just need to tweak the expression a little bit.