maahutch
2 years agoNew Contributor
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 | 8/21/23 |
I'm trying to merge them together to get a final product like this:
FirstName | LastName | Title | Value |
Ann | Smith | Ms | 8/21/23 |
June | Jones | Mrs | 8/21/23 |
Sam | Johnson | Mrs | 8/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