https://community.esri.com/t5/arcgis-survey123-questions/join-function-for-select-one-from-file-in-repeat/m-p/1223690#M45447 <P>Hi all.&nbsp; Having a minor issue using the join function with a repeat.&nbsp; I have a csv file (very large) and using a select_one_from_file question, I select a species.&nbsp; I answer a couple of related quality questions, and then add another item to the repeat, choose another species, etc.&nbsp; Outside of the repeat I have used the join function, join(";",${dom_trsh}) to attempt to produce a list of the species chosen (this is what I expect:&nbsp; "acacia;pinus;calocedrus;aricaceae", but instead of getting a joined list of species (like a concatenate), I end up with this instead: "1;34;14;6".&nbsp; It seems like the join is getting the row number of that species from the csv file rather than the species name itself.&nbsp; In the form and in the submitted data, the species is there.&nbsp; But, when the calculation is done, I get the numbers instead.</P><P>Anyone have any ideas of how to rectify this?&nbsp; Thanks in advance....</P> Thu, 20 Oct 2022 03:47:10 GMT BryanTaylor13 2022-10-20T03:47:10Z https://community.esri.com/t5/arcgis-survey123-questions/join-function-for-select-one-from-file-in-repeat/m-p/1223690#M45447 <P>Hi all.&nbsp; Having a minor issue using the join function with a repeat.&nbsp; I have a csv file (very large) and using a select_one_from_file question, I select a species.&nbsp; I answer a couple of related quality questions, and then add another item to the repeat, choose another species, etc.&nbsp; Outside of the repeat I have used the join function, join(";",${dom_trsh}) to attempt to produce a list of the species chosen (this is what I expect:&nbsp; "acacia;pinus;calocedrus;aricaceae", but instead of getting a joined list of species (like a concatenate), I end up with this instead: "1;34;14;6".&nbsp; It seems like the join is getting the row number of that species from the csv file rather than the species name itself.&nbsp; In the form and in the submitted data, the species is there.&nbsp; But, when the calculation is done, I get the numbers instead.</P><P>Anyone have any ideas of how to rectify this?&nbsp; Thanks in advance....</P> Thu, 20 Oct 2022 03:47:10 GMT https://community.esri.com/t5/arcgis-survey123-questions/join-function-for-select-one-from-file-in-repeat/m-p/1223690#M45447 BryanTaylor13 2022-10-20T03:47:10Z https://community.esri.com/t5/arcgis-survey123-questions/join-function-for-select-one-from-file-in-repeat/m-p/1224949#M45547 <P>All sorted.&nbsp; My form was referencing an updated .csv file which did in fact have numbers in the "name" field, instead of a copy of the species name.&nbsp; It is working perfectly as advertised.</P> Mon, 24 Oct 2022 22:27:19 GMT https://community.esri.com/t5/arcgis-survey123-questions/join-function-for-select-one-from-file-in-repeat/m-p/1224949#M45547 BryanTaylor13 2022-10-24T22:27:19Z