No-code (UI) joins with error when same field used

Bug reports
1

Hey guys, I've alreay created that topic, but I would like to create another one based on the same problem.

I'm trying right now the version v0.47.0.
If I try to join the same field from the same table in the no-code interface from two different Saved Question, it does not work.

How to simulate the problem:

  1. Create a question -> select Sample Database -> Orders: Sum of Tax and group by Product -> Category -> Save the question
  2. Create a question -> select Sample Database -> Reviews: Avg of Rating and group by Product -> Category -> Save the question.
  3. Try now to join both questions in the no-code interface, the join should be on Product -> Category.
    The output shows only the results of the first question. If you go back to "Show Editor", you'll see that the join was removed.

That fix would enable several no-code analysis in my company.
Thanks.

2

Did this work before v47?

3

No it didn't. But before v47 we receive an error "Cannot find matching FK Table ID for FK Field null."
In v47 it simply undo the join.