2 Replies Latest reply: Jul 16, 2018 7:16 AM by Sunny Talwar RSS

    Flag creation help

    Mahitha M

      Hi Experts,

       

      Can any one please help me on below requirement.

      I have Two Tables Table1 and Table 2 like below with the below data

       

      Here need to compare Table 1 ID with Table 2 ID.If Table1 ID exists in Table 2 then Status is Yes else No.

       

      Please help me to do in backend.

       

      Thanks in advance

        • Re: Flag creation help
          Francesco Reggiani

          TableMap:

          Mapping load

          Employee ID ,

          'Yes' as Status

          from Table2;

           

          Table1:

          Load

          ApplyMap('TableMap',[Employee ID],'No') as Status,

          [Employee ID],

          [Employee Name],

          Startdate 

          EndDate 

          Company

          From Table1;

          • Re: Flag creation help
            Sunny Talwar

            Here is another option

             

            Table2:

            LOAD [Employee ID],

                 [Employee Name],

                 Startdate

                 EndDate

                 Email

            From.....

             

            Table1:

            LOAD [Employee ID],

                [Employee Name],

                Startdate

                EndDate

                Company,

                If(Exists([Employee ID]), 'Yes', 'No') as Status

            From.....

             

            This is assuming that Table1 will have all the Employee ID, and Table 2 will have subset of Employee ID from Table 1