How to append new column into existing data

Question

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 Answer

Hi @hegdepavithra10

You can do this by using a Join with this configuration

atcodedog05 · Accepted Answer

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 Answer

@hegdepavithra10

Here is the sample workflow for you.