title: How deal with flatten operator when we use conditional
body: <p>I want to use <code>flatten</code> operation in conditional operation :</p>
  
  <pre><code>((FLATTEN(LIMIT_CEP.CD_AXE_MCH) == 'PME') ? 'E':'F')        AS CD_AXE_MCH_GCP,
  </code></pre>
  
  <p>Because <code>LIMIT_CEP.CD_AXE_MCH</code> is given like :</p>
  
  <pre><code> {(COMM)}
   {(ARTI)}
  </code></pre>
  
  <p>But the problem here that the program return this error message</p>
  
  <blockquote>
    <p>Syntax error, unexpected symbol at or near 'FLATTEN'</p>
  </blockquote>
  
  <p><strong>EDIT :</strong></p>
  
  <p>I tried also something like :</p>
  
  <pre><code>FLATTEN((LIMIT_CEP.CD_AXE_MCH=='PME') ? ('E') : ('P'))   AS CD_AXE_MCH_GCP,
  </code></pre>
  
  <p>But I got this error :</p>
  
  <blockquote>
    <p>mismatched input '?' expecting RIGHT_PAREN</p>
  </blockquote>
  
  <p>How can I resolve it please ?</p>