13 Replies Latest reply: Jan 10, 2018 6:52 AM by beck bakytbek RSS

    Two Fields into one Field as Filter

    beck bakytbek

      Hi Folks,

       

      i have an situation which does look like, our customer deleloped the database, within this database we have a tables with 3 fields:

       

      Project,   Project_Manager1,    Project_Manager2

       

      A,               Mike,                     Simon

      B,               Tom,                      Frank

      C                Yoko                        Will

       

      i know this database does look like a bit funny, but as you know : Your Customer is your King

       

      i have a question: How can i combine these Fields: Project_Manager1, Project_Manager2 into one Field: ProjectManger

       

      my expected Output is:


      Project    and Filter as ProjectManager

      A               Mike

                     Simon

      B               Tom

                     Frank

      C               Yoko

                      Will

       

      thanks a lot

      Beck