title: How to parameterize IN clause in SQL Query to use in JMETER
body: <p>I need to parametrize a SQL Query to use in JMETER such that every time it triggers, a random value is picked from the list of values to be used in IN clause.</p>
  <p>Parent Query - Select * from Employee where Emp_Id in ( 3,9,11,12,13) and Dept_Name in('HR',IT','Admin','Audit')</p>
  <p>Post the Parameterization when i trigger the Query through JDBC Request the request run for different user needs to have random selection made.
  Ex:
  Query 1 should be like - Select * from Employee where Emp_Id in ( 3,9) and Dept_Name in('HR',IT')</p>
  <p>Query 2 should be like - Select * from Employee where Emp_Id in ( 11,12,13) and Dept_Name in('HR',IT','Admin')</p>
  <p>I am trying to use CSV Data Set Config but not able to achieve the above output.</p>