7 Replies Latest reply: Sep 9, 2016 8:45 AM by Jayaseelan K RSS

    Can someone please explain how Join and concantenation works here together.The code is below

    Ankit Chaudhary

        left join ([Total Cases Created])

       

        Load

          OrgID as TCC_OrgID,

          TicketID as TCC_TicketID

      Resident [ticket];

       

        CONCATENATE ([Total Cases Created])

       

        Load

        "KNOX TicketID" as TCC_TicketID,

          'KNOX' as TCC_ServiceType

         Resident [BPST KNOX ];