Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please i need to create a new calculated field in my table , this field must retern YES or NO value
try simple
if(Field=100,'Yes','No')) as Temp
thank you for your response Chanty 4u
What field and value you looking into to convert to YES and NO?
Hello ,
I want to create a new field that, depending on the value of other fields, it displays NO or YES
EX:
If: In this date: 'xx / xx / xxxx', IDOperation = 'A number' then This client has an operation this week: YES
If no>: NO
Not sure but if all of your fields are in single table it would be much easier.
You can do preceding load with in the table to create a new field as below
Ex:
Table1:
Load*,
if(Datefield>= 'xx / xx / xxxx' and IDOperation='A number','YES','NO') as OperationFlag;
Load
Field1
Field2
Datefield
IDOperationField
Field5 and so on....
From....xls;
Please check the syntax for above if condition.
Hope that works?
thanks you Aehman K !