External CSV Not Iterating Through Multiple Records in Repeat Group - Only Pulling First Record

[ahblake]

As your file does have an AP integer index # beginning with 1 for each facility, and you can count the number of APs per facility correctly, you could look up each one matching the repeat position with the index #.

eg:

• put a calculate field in the repeat like ${repeat_index} with a calculation position(..)
• have another calculate that gets the AP text like instance('action_points')/root/item[facility_name = ${facility}][${repeat_index}=point_index]/label
• and another that replaces label with action_point_id

But if you make an error in the point index (skip or duplicate a value) it will break, so you could be fancy and ignore the index value completely and simply pull the values in the order they exist in the file where list order value = repeat position value, eg:

• have a calculate that gets the AP text like instance('action_points')/root/item[facility_name = ${facility}][position()=position(current()/..)]/label

Some of what I was trying recently might also help you, as I was dynamically building and populating repeats:

Filtering values in a repeat, in another repeat. indexed-repeat issue and Enketo vs Collect/webforms difference in behaviour

Continuing from my troubles with tribbles dynamic repeat labels, now I'm trying to filter the contents of a repeat... dynamically 1. What is the issue? Please be detailed. I have a form where the enumerator selects one item, then via a repeat reports a variable number of findings against it. The findings (child) are identified from a select one, and each is assigned to a parent category via a field against the choice/entity list. Each response against the finding has an associated severity val…

BTW: your facilities choice list has spaces in it, it would be better to remove these as spaces are used to separate select multiples, nodesets etc.