Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have a table like this and i dont want Customet No which starts from CU.How can i acheive this .i need help to get this solve .
Customer:
LOAD
No_ as [Customer No_],
Name as [Customer Name],
[Customer Disc_ Group],
Channel as ChannelGroup,
[Customer Type],
[State Code],
City as CustomerCity,
FROM
(qvd)
where Customer_No!='C*';
thanks,
mohan
Hi,
Try this:
Customer:
LOAD
No_ as [Customer No_],
Name as [Customer Name],
[Customer Disc_ Group],
Channel as ChannelGroup,
[Customer Type],
[State Code],
City as CustomerCity,
FROM
(qvd)
where left(No_,2)<>'CU';
Hi Mohan,
Try this:
where Not WildMatch(Customer_No,'C*');
Regards,
Sokkorn
try like
where Customer_No<>'C*';
Try
Customer:
LOAD
No_ as [Customer No_],
Name as [Customer Name],
[Customer Disc_ Group],
Channel as ChannelGroup,
[Customer Type],
[State Code],
City as CustomerCity,
FROM
(qvd)
Where not(wildmatch(Customer_No,'CU*'));
Regards,
Kaushik Solanki
Hi,
Try this:
Customer:
LOAD
No_ as [Customer No_],
Name as [Customer Name],
[Customer Disc_ Group],
Channel as ChannelGroup,
[Customer Type],
[State Code],
City as CustomerCity,
FROM
(qvd)
where left(No_,2)<>'CU';
Thanks for quick response Borja.
Regards,
Mohan.