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
Spammy spam, oh so sly,Filling inboxes, oh my, my.Clickbait words and tricks they play,Trying to lead us all astray.
Spammy spam, we’ll delete you,No more tricks, we see right through.Unwanted emails, be gone far,Spammers, you won’t get too far.
Spammy spam, just a bother,Trying to sell what we don’t want, brother.We’ll report you, make you flee,No more spamming, let us be free.
Spammy spam, it’s no game,We won’t fall for your false claim.Respect our inbox, hear our plea,Spammers, now it's time to flee.