Hi there, I'm trying to pull data from a csv file. I have three people named ''Grace''. When I try to pull any one of them, its only the first ''Grace'' who is being pulled out. Any idea on how to fix this? Also there is repeat function in the tool. Is there a way that, when you fill information for a particular entry, you are restricted from repeating the same entry? Attached my Xls form and csv
School profile.xlsx (11.1 KB)
students.csv (154 Bytes)
Hi @David_Roba
pulldata always returns just one value (or nothing if there is no match). If you have multiple rows in your csv file with the same name and you try to use the function using that name the first one will always be returned. You need to distinguish those rows somehow so that the value you are using is unique.