12 Replies Latest reply: Mar 21, 2016 1:32 AM by Ashwani Kumar RSS

    Understanding Script

    Shan Ahmed



      I have a code in my script like this that somebody has written previously:

      If(Sales> '0' or [Sales Flag] = 'Y', 'Y', 'N') as WarrantFlag


      What is this code mean?


      Is it like this? if sales is greater than zero or Sales flag = Y then Y otherwise N.


      If i want to us these piece of code in where clause after the load statement then how should i write the code?