Survey banner
The Dataiku Community is moving to a new home! We are temporary in read only mode: LEARN MORE

UI looks wrong when joining a dataset with itself

ABE
Level 1
UI looks wrong when joining a dataset with itself

Hello,

For a project I'm currently working on, I need to join a dataset with itself using different filters and computed fields each time.

=> something that would look like

SELECT *

FROM (SELECT computed_field_1 FROM data WHERE filter_1) AS data_1

JOIN (SELECT computed_field_2 FROM data WHERE filter_2) AS data_2

ON data_1.computed_field_1 = data_2.computed_field_2

All of this should be doable inside a join recipe using the pre-filter and pre-join computed columns capabilities.

However, it appears there's a problem in the UI: the pre-join computed columns of the rightmost table of the join cannot be selected either in the "join" or in the "selected columns" pannel.

Does anyone else face the same issue and know a workaround? (except using first a filter recipe before the join recipe or switching to a SQL recipe, as both are not suitable in my case).


Operating system used: windows

0 Kudos
1 Reply
ktgross15
Dataiker

Hi @ABE ,

Thanks for reporting this. It looks like there is a bug here - we will work to get it resolved as soon as possible and will keep you updated on status.

Best,

Katie