Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
after Binary call I would like to create a new field and then use it inside "Where"
i tried this:
NoConcatenate
Sales2:
Load
*,
if(Sales.Brand = 'SM', '1', '0') as "Co Flag"
Resident Sales;
NoConcatenate
Sales3:
load *
resident Sales2
where "Co Flag" = '1';
drop Tables Sales3,Sales2;
but it does not work, can someone help me understand why?
Hi, it appears you dropping the output table. I'd rather you do it as below.
NoConcatenate
Sales2:
LOAD *
Where "Co Flag" = 1 ;
Load * ,
if(Sales.Brand = 'SM', '1', '0') as "Co Flag"
Resident Sales;
DROP Table Sales;