If condition in load column

[0li5a3a]

Hi,

I want to make a new column in my table.

table:

load 

     order_no,

     customer ref no,

     date

from xyz.qvd

My customer ref no column  contain information like :

1234568

abcdefg

321456

RMA:123456/0

RMA:abcdef/0

I want to make a column  what will contain just these customer ref no's information:

1234568

abcdefg

321456

Can I use IF condition to do this?

if(customer ref no = RMA:, ignore and go to next customer ref)

Could someone help me with my problem please.

Best Regards,

Constantin

[ankit777]

Hi

try this in where condition:

left([customer ref no],3) <> 'RMA'

[ankit777 · Accepted solution]

if you want to do this for one column do this:

if(left([customer ref no],3) <> 'RMA',[customer ref no]) as column_name

[0li5a3a]

Thanks for your answer. Is really helpful!