Compare two dataets rows and insert into new coloumn
Options
sasidharp
Registered Posts: 27 ✭✭✭✭
I have two datasets which have columns.
dataset 1:
| tag |
| n1 |
| n2 |
| n3 |
| n4 |
Dataset2:
| id |
| n1 |
| n2 |
| n3 |
I want my output dataset as
| tag | id | status |
| n1 | n1 | A |
| n2 | n2 | A |
| n3 | n3 | A |
| n4 | M |
How can i do it Dataiku?
Best Answer
-
Thanks @Liev
for your reply, i have tried different way using prepare recipe and formula process, it worked.initially i ran this on spark engine, but the output cam wrong, changing into DSS it's working fine.
Answers
-
Hi @sasidharp
Yes you can. But in order to make it easier you should include the row number on each of your columns, then you can indeed join (left join in your case) using this field.
You can compute the row number using a window recipe on each of your datasets before the join.
Good luck!
