How to append new column into existing data

[hegdepavithra10]

Hi,

I have the below data 

Existing:

New

I am expecting the following output:

I tried to use append fields , but the existing data is repeating for every new row.

Can someone help.

[joshuaburkhow · Accepted solution]

Hi @hegdepavithra10 

You can do this by using a Join with this configuration 

[atcodedog05 · Accepted solution]

Hi @hegdepavithra10 

Here is a workflow for the task.

Workflow:

Use Multiple Join to get Full join

Hope this helps 🙂

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

[Qiu · Accepted solution]

@hegdepavithra10 

Here is the sample workflow for you.

[Qiu]

@atcodedog05 

Nice one!

[atcodedog05]

Happy to help 🙂 @hegdepavithra10 

Cheers and Happy Analyzing 😀