4 Replies Latest reply: Feb 8, 2016 7:37 AM by Alex Millan RSS

    Problem with where clause

    Priyanka Pandey

      Hi All,

       

      I am stuck at some point in development process and would need you help and suggestions.

       

      My excel file contains data in the format as specified below.   

      NameProd/Non ProdActivity
      AmitProdCall
      AmitProdMeeting
      AmitProdTest
      AmitNon ProdBreak
      MonikaProdCall
      MonikaNon ProdBreak
      MonikaNon ProdGames
      MonikaNon Prodcheck mail
      PriyankaProdQA
      PriyankaProdCall
      PriyankaNon ProdBreak
      PriyankaNon Prodcheck mail
      SarveshProdTest
      SarveshProdMeeting
      SarveshProdQA
      SarveshNon ProdBreak
      SumitProdCall
      SumitProdTest
      SumitProdMeeting
      SumitNon ProdBreak
      VikasNon ProdBreak
      VikasProdQA
      VikasNon Prodcheck mail
      VikasNon ProdGames

         

       

      I need to load data on following conditions only

       

      1. Remove break from Activity column for all Names.
      2. For Name = 'Priyanka' and 'Vikas' remove all 'Non Prod' Values
      3. For Name = 'Priyanka' and 'Vikas' remove all QA columns
      4. Except above conditions all rows must be loaded