5 Replies Latest reply: Jul 11, 2013 7:22 AM by Mohanraj Subramanian RSS

    urgent

    Mohanraj Subramanian

      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

      [E:\QlikView Apps\Data\QVD\Customer.qvd]

      (qvd)

      where Customer_No!='C*';

       

       

       

      thanks,

      mohan