Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Data:
LOAD
if(Frm<=4,Frm) as Frm,
if(Frm>4,Frm) as To
FROM ....
Hi,
try like
load
if(code=4,Code) as Frm,
if(code>4,Code) as To
from table;