I can't think of an easy way to do this with the stock functionality. If you could get the second CSV into a sampler somehow, you could probably use a RegEx Extractor to find the values that you need.
Some better solutions would be: - Try to give the HTTP sampler a file: URL. It might work :) - Build a File Reader plugin that accepts a path (JMeter plugins are easy) and search as below - Extend the File Reader to handle searching your file A hackish short term solution would be: - Replace the commas in the first CSV with pipes "|" for use in a regex, or use a BSF/BSH sampler to do the substitution on each iteration - Put the second CSV somewhere web-accessible (eg, a local instance of Apache, or Jetty) - Visit file with an HTTP sampler. - Use the input CSV's value in the regex extractor with something like \b($keys)\b, which maps to something like \b(key1|key2|key3)\b(.*) that will match any key thanks to alternation On Wed, Jan 7, 2009 at 9:09 AM, SK3 <[email protected]> wrote: > > Hi. > > I have the following problem and i haven't been able to find a way to do it > yet. > > I need to create a script that would read from two CSV files. > One file has a list of codes (among other things) and in the other file i > have a line for each code, and a list of values in that line. (It's like two > tables in a database with a foreign key). > I want to read the first CSV file in a normal way, and for each code, to > pass through all the lines in the second CSV file and when i reach the line > with a code that is equal to the code from the first file, to load the > values in that line into variables. > > I can't seem to do it, Jmeter always reads the same line number from both > CSV, i can't make it read a different line number when it's a different CSV > file (an ideal way would be to put one CSV Data Set Config object as a child > of the other one). > > Is it possible to do what i want? If so, how? > Thanks. > -- > View this message in context: > http://www.nabble.com/How-do-i-point-to-a-CSV-file-value-from-another-CSV-file.-tp21326551p21326551.html > Sent from the JMeter - User mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
