Get Values in CSV File | XM Community
Skip to main content
Question

Get Values in CSV File

  • August 18, 2021
  • 1 reply
  • 34 views

Hello!
I am a Qubie - not very familiar with JS.
I have a CSV with two columns: identifier & value. Based on some question's answers I generate the identifier. Now I want to look in the CSV to get the corresponding value for further calculations.

identifier, value
xb39, 1100
xc20,1200
xd27,900

How can I (1) get the CSV loaded and (2) get the value which matches the identifier of the respondent? The CSV is uploaded in the Qualtrics library. The corresponding value will be used as piped text (embedded data) in the following questions.

Thanks in advance for any help :)

1 reply

grahulp5
QPN Level 3 ●●●
Forum|alt.badge.img+13
  • QPN Level 3 ●●●
  • August 26, 2021

If you have imported csv in Qualtrics you can directly use filter to get your required values by using contains or equal to operations.