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

suem over 10 years ago

Hi
I have a ReviewDocuments CDT which contains two multi value child CDTs.
I have a documents array containing 2 documents and a CDT FieldworkAnalyticalReview array with 3 sets of details.
Each FieldworkAnalyticalReview needs to be associated with each of the documents
i.e.
Documents: {A,B}
FieldworkAnalyticalReviews: {1,2,3}
Which needs to become :
1.          ReviewDocuments CDT ID=1 with 1A
2.          ReviewDocuments CDT ID=2 with 1B
3.          ReviewDocuments CDT ID=3 with 2A
4.          ReviewDocuments CDT ID=4 with 2B
5.          ReviewDocuments CDT ID=5 with 3A
6.          ReviewDocuments CDT ID=6 with 3B

What would be the best way to achieve this.
Thanks

Discussion posts and replies are publicly visible

Parents

0 suem over 10 years ago

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
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 suem over 10 years ago

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
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data