title: Netezza- Concatenate Different Values from Single Column based on Order from another Column
body: <p>I am trying to do a column concatenate based on order of Sample Counter and by ID field. Below is an example of the data</p>
  
  <pre><code>**Heat ID**  **Sample Type**  **Sample Counter**
    466170            T1                2 
    466170            L0                3
    466170            C1                4
    466170            V2                1
    580910            C1                1
    580910            L0                2
    580910            T1                3  
  </code></pre>
  
  <p>This is what I want below. So I want it concatenated by ascending sample counter I guess you could say.</p>
  
  <pre><code>**Heat ID**  **Concat Code**
    466170       V2_T1_L0_C1
    580910       C1_L0_T1
  </code></pre>
  
  <p>The data is structured so that not every heat ID will have the same amount of Sample Types and the Sample Types are in different order. Sample counter is when the different Sample Type is used (The Order). Any help would be greatly appreciated. Thank you!   </p>