Hi @Uditha
Welcome back to the community forum. Kindly attach the XLS file and CSV files as attachments so that we look at them. I was not able to amend the link you had shared.
Hi @Uditha
I was able to find your problem and we should be able to update our article to answer this very problem.
You are pulling data by referencing text from a select one question. This should work very well not a problem.
However, select_one questions do not store the label but rather the name which will be used to operationalize the pull data functionality. See screensot below to explain
To resolve this, kindly change the items in the column labeled drug for your CSV to correspond to what is in the column labelled name within the survey sheet of your XLS form. Just as an example, you can replace 8X Shampoobottle of 60 ml Shampoo with option_1 in your csv file and the pull data will work pretty fine. You may want to add a column on the CSV with drugname so that you can preserve the drug name for future reference.