4 Replies Latest reply: Oct 24, 2017 8:18 AM by Joris Lansdaal RSS

    not expected duplicate lines

    Joris Lansdaal

      Hi all,

       

      There's a field called 'Omschrijving' and when this field contains "accrual" the Field TYPE_2 will be discounts_accrual and otherwise discounts.

      I used the below logic that seems to work but gives me duplicate lines when the logic is true.

      if(Len(SubField(Lower(Omschrijving),'accrual'))<Len(Omschrijving),'Discounts_accrual','Discounts') as TYPE_2.

       

      Can anyone tell me why this is happening and wether there's a better way then using subfield?

       

      regards Joris