Forum Discussion

maahutch's avatar
maahutch
New Contributor
2 years ago
Solved

Add column to document and repeat value in each row

I have one document structured like this: 

FirstNameLastNameTitle
AnnSmithMs
JuneJonesMrs
SamJohnsonMrs

And a second document like this: 

LabelValue
MyEvent8/21/23

I'm trying to merge them together to get a final product like this: 

FirstNameLastNameTitleValue
AnnSmithMs8/21/23
JuneJonesMrs8/21/23
SamJohnsonMrs8/21/23

I'm trying to append the Value column and repeat the value for every row in the first table. I've tried Union and Join but without success. What would be the correct Snap for this use case? 

 

 

 

  • 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