topic Re: Cannot define the join in Data Catalyst design in Catalog and Lineage

Cannot define the join in Data Catalyst design

alis2063 — Tue, 07 Dec 2021 22:35:04 GMT

i am trying to define the join between two table unfortunately it does not show the table name in "join Criteria"

Please guide if i am doing something wrong

here it snapshot i am not getting origin table name i.e My_Patient_Profile /my_Patient instead of that i am getting Master/Detail.

Re: Cannot define the join in Data Catalyst design

alis2063 — Tue, 05 May 2020 06:52:03 GMT

Kindly ignore it as its resolved

Re: Cannot define the join in Data Catalyst design

davidhowland — Tue, 05 May 2020 14:55:03 GMT

Hello. So to create this join for three tables, you will need to joins. Table1 and Table2 will be joined, and then output of that will be joined to Table3. The result of that join can be the end entity you're trying to create, or it can be yet another join. But to start you want to drag the circle on the entities to from Table1 and Table2 to the square on the join button, define join criteria ... and so on.
Hope that helps.
David