Field Value Array

[mrainey18]

Is there a way to put a list of Distinct field values into a variable array?

I am trying to create a nested For each next loops where the loops loop through each distinct field value. 

[sunny_talwar · Accepted solution]

May be do this with FieldValue() and FieldValueCount() function

For i = 1 to FieldValueCount('FieldName')

     LET vVar = $(vVar) & FieldValue('FieldName', $(i));

NEXT i

Something along these lines