Forum Discussion

maahutch's avatar
maahutch
New Contributor
3 years ago
Solved

Add column to document and repeat value in each row

I have one document structured like this:  FirstName LastName Title Ann Smith Ms June Jones Mrs Sam Johnson Mrs And a second document like this:  Label Value MyEvent ...
  • ivicakoteski's avatar
    ivicakoteski
    3 years ago

    Hi maahutch ,

    You can try Join Snap. You will need to specify the type Inner Join and hardcode the value 1 as the left and right paths.


    And after that in the mapper snap, you will remove the Label column, or you can use this mapper for removing the Label column before the join snap. 🙂


    Hope this helps!
    BR.
    Ivica

alchemiz's avatar
alchemiz
Contributor III
3 years ago

Hi maahutch ,

Good day,  here's my suggestion first convet the second document into a key-value pair then use join snap to merge it from the streaming documents

I assume that the value from "Label" will be the keyname then value from "Value" will be the value

Expression: sl.ensureArray($.values().join('|')).toObject(v=> v.split('|')[0], v=> v.split('|')[1] )
Target Path: $