Compare two dataets rows and insert into new coloumn

Solved!
sasidharp
Level 3
Compare two dataets rows and insert into new coloumn

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

tagidstatus
n1n1A
n2n2A
n3n3A
n4 M

 

How can i do it Dataiku?

@fchataigner2

 

0 Kudos
1 Solution
sasidharp
Level 3
Author

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.

 

 

View solution in original post

0 Kudos
2 Replies
Liev
Dataiker Alumni

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!

0 Kudos
sasidharp
Level 3
Author

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.

 

 

0 Kudos