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
HI, Here you can use CDT.
Then create a new expression.
a!localVariables( local!table1: { { column1: 1, column2: 2 } }, local!table2: { { column1: 1, column2: "King" }, { column1: 1, column2: "Queen" }, { column1: 2, column2: "Queen" } }, a!forEach( index( local!table2, wherecontains( local!table1.column1, local!table2.column1 ), {} ), 'type!{urn:com:appian:types:AC}AC_testCdt'( table1column1: local!table1.column1, table1column2: local!table1.column2, table2column1: fv!item.column1, table2olumn2: fv!item.column2 ) ) )
Can't we use record for relating two unrelated tables? If no, why?
Yes, we can use in the same way.