title: how to pass an array into update query kdb
body: <p>Hello I have the following code that I would like to find the optimal way of passing the array of any size without having to explicitly do it line by line:</p>
  
  <p>the two arrays are coeffs and tickers. thank you</p>
  
  <pre><code>t:update Value:Value*coeffs[0] from (select from t)where Code in `$tickers[0];
  t:update Value:Value*coeffs[1] from (select from t)where Code in `$tickers[1];
  t:update Value:Value*coeffs[2] from (select from t)where Code in `$tickers[2];
  t:update Value:Value*coeffs[3] from (select from t)where Code in `$tickers[3];
  t:update Value:Value*coeffs[4] from (select from t)where Code in `$tickers[4];
  </code></pre>