Combining 2 similar recordtypes

Hi All,

I have 2 tables TABLE1 and TABLE1_HISTORY. I need to combine latest 1 row from TABLE1 and few historical rows from TABLE1_HISTORY and display the values in a single grid.

Instead of using UNION to combine the 2 tables using DB views or querying the 2 tables separately and combine in Appian side , is there a way to union 2 tables using recordtypes ?  relationship creation is not working as the PK / FK  relationship doesn't exist.

Note Here: As per our current design , the common field between the 2 tables are not a PK field in either of the tables because of which i am not able to create relationship as join / union in SQL. 

Appreciate the suggestions. Thanks in advance 

Raj

  Discussion posts and replies are publicly visible