Hi I have a ReviewDocuments CDT which contains two multi value child CDTs.

Use a join table between FieldWorkAnalyticalReview and Documents. This may be called FieldWorkAnalyticalReview_Document. There will be at least 3 fields - add other metadata fields as you like. The ID (primary key) of this type, the foreign key ID of the Document, and the foreign key ID of FieldWorkAnalyticalReview. I would probably recommend not nesting the types - as in the screenshot. Your queries may return more data than you need. You could just soft-link by ID.

We're having trouble with the syntax required to populate the cdt for the join table. We've tried lots of different combinations but haven't hit the right combination of functions yet. Any ideas on that please.

Hi Suem,
Not sure if you have already gone through the below related forum posts link :
forum.appian.com/.../e-145331
forum.appian.com/.../e-190101
forum.appian.com/.../e-153616
Please check if it helps.

Bit of a complex one this, but the below pretty much does what you want. Sue - I'll contact you directly with a more complete solution.

load(
local!documents: {"A", "B"},
local!reviews: {1, 2, 3},
local!reviewArray: reduce(
fn!append,
{},
apply(
fn!insert(
{},
local!reviews,
_
),
enumerate(
length(
local!documents
)
) + 1
)
),
local!documentArray: reduce(
fn!append,
{},
apply(
fn!insert(
{},
local!documents,
_
),
enumerate(
length(
local!reviews
)
) + 1
)
),
apply(
fn!concat(
_,
_
),
merge(
local!reviewArray,
local!documentArray
)
)
)

Hi thanks sonalk, Phil. I'll try out the apply merge approach as it looks like it will do exactly what we want. Thank you

Hi all, I’m afraid we’ve had to re-work our output CDT to match others in the system so it’s been simplified to the following:
ReviewDocument :-

The two input CDTs, Documents and Reviews:-

For each combination of Review and Document we need to write a ReviewDocument.
For example if we have 3 rows in Review {“A”,”B”,”C”} and two in Document {1,2} then the output ReviewDocument will contain 6 rows ie A1, A2, B1, B2, C1, C2 where ReviewDocument .farId = gtFieldworkAnalyticalReview.id and ReviewDocument .assignmentDocumentId = gtassignmentDocument.appianDocumentID

So far we have had little success in nesting the functions and have yet to discover the correct combination which seem endless -
single rule in a script task output, or via the script task inputs or possible using an MNI?
thanks