Copy column from one dataframe into another based on condition

I have two dataframes.
The first one has many variables, and the second one only two.

Dataset1: ID, var1, var2, var3…
Dataset2: ID, IDv2

As you could see, dataset2 has two different type of identifications, which in reality is the same variable but with different format.
e.g.:
ID IDv2
1 1_a
1 1_a
1 1_a
2 2_a
2 2_a

What I want is to have the column IDv2 in the first dataframe.

Hi,

You can use the Joiner node, as matching criterion use the ID.

Before that I will pass the second table in the Groupby node to get unique values for the ID

Regards

5 Likes

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.