Relate Data from two unrelated tables.

Certified Senior Developer

Hi,

Please let me know the solution for this, with proper justification.

You have data from two unrelated tables. Which Appian objects can easily relate data from these two tables?

a)custom data type

b)Expression rules

c)Record Types

d)process models

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer

    Hi Kirang

    In the latest version of Appian using Record Types for relationship are the recommended method for connecting different data sources or different tables

    This can also be achieved by -

    1) Creating a view in DB with the tables required and then making a CDT of the view.

    2) (Least Preferred) Having tables joined by foreign key and then creating nested CDT to access data of the linked table via main table

    Please flag the question as answered as it can help other people.

    Amitesh Singh

  • 0
    Certified Senior Developer
    in reply to amiteshsin
    Creating a view in DB with the tables required and then making a CDT of the view.

    Is it possible to have a view with no common field defined in both the tables? How will we create the view on totally non related tables.

    for point number 2, how do we connect two unrelated tables?

    What exactly is the answer of above question.

    Is it CDT or Record Types or expression rules?

Reply Children