You now have until September 15th to submit your use case or success story to the 2022 Dataiku Frontrunner Awards!ENTER YOUR SUBMISSION

Does Dataiku have Set Operation such like UNION, INTERSECT in SQL?

Solved!
p_phanwong
Level 2
Does Dataiku have Set Operation such like UNION, INTERSECT in SQL?

I noticed this question when I was using a Stack recipe with uploaded dataset. The Stack recipe works like UNION in SQL but has only schema selecting option.

Is there anyway to use Set Operation on the uploaded dataset?

or we can only use SQL code recipe with database-dataset? (haven't try this yet) 


Operating system used: Windows 10

0 Kudos
1 Solution
fchataigner2
Dataiker
Dataiker

Hi,

an "intersect" would be done by a join, more precisely an inner join. You can do one on uploaded files datasets with a Join recipe. Note that the default join type in a join recipe is left outer join, so you have to change it in the modal of the join definition.

View solution in original post

0 Kudos
1 Reply
fchataigner2
Dataiker
Dataiker

Hi,

an "intersect" would be done by a join, more precisely an inner join. You can do one on uploaded files datasets with a Join recipe. Note that the default join type in a join recipe is left outer join, so you have to change it in the modal of the join definition.

0 Kudos