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


      B               Tom


      C               Yoko



      thanks a lot