How to Exclude other Field Values within same Fieldname?

[#1]

Hi All,

How do i Assign or Exclude New Fields  like Below:

Code  as Frm,

if(Code>4,Code) as To,

Output:

Frm,

4,

To,

5,

6,

7,

8

[Gysbert_Wassenaar]

Data:

LOAD

     if(Frm<=4,Frm) as Frm,

     if(Frm>4,Frm) as To

FROM ....

[PrashantSangle]

Hi,

try like

load

if(code=4,Code) as Frm,

if(code>4,Code) as To

from table;