Appending on basis of Id of Mapping

[Mukeshy12390]

Hi Everyone - 

I have been trying to build solution where I need to append some data through mapping  based on "ID"  to input.

Here is the example . pls let me know in case any other details.

Input data	ID	Code
	mks123	100
	mks1234	200
Mapping	ID	Code
	mks123	50
	mks123	40
Target Output	ID	Code
	mks123	100
	mks123	50
	mks123	40
	mks1234	200

[PhilipMannering]

Judging by the output, it looks like all you want to do is Union the tables (stack vertically). Try the Union Tool

[Greg_Murray · Accepted solution]

@Mukeshy12390,

Are you checking to see if the mapping ID values exist in the input before adding them in? If so, this should do it. 

[atcodedog05]

Hi @Mukeshy12390 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[PhilipMannering]

@atcodedog05 That looks very similar to my solution... I don't think the duplication is necessarily helpful.

[atcodedog05]

Sorry just happens to be a late submitter 😅 I had forgot to hit post.

[Mukeshy12390]

Thanks everyone for the quick reply, all given solution work feeling so dumb right now:)

[atcodedog05]

Hi @Mukeshy12390 

Chill its better know the answer then to be left with an answered question.

Please dont hesitate to ask a question and miss out one of the great ways to learn 🙂

Feel free to reach out if you face any issues 🙂

Happy to help 🙂

Cheers and Happy Analyzing 😀