Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this?
If(WildMatch(Omschrijving, '*accrual'*), 'Discounts_accrual','Discounts') as TYPE_2
May be this?
If(WildMatch(Omschrijving, '*accrual'*), 'Discounts_accrual','Discounts') as TYPE_2
Provide sample data may be it is due to Subfield that you use on the Logic due that it created two rows better to looking on sample data though.
May be this
if( WildMatch(Lower(Omschrijving),'*accrual*','accrual*','*accrual'),'Discounts_accrual','Discounts') as TYPE_2
Thanks! Wildmatch is shorter and does not duplicate!