1 Reply Latest reply: Jun 28, 2017 9:30 AM by Erich Shiino RSS

    Geração de um QVD a partir de outros 2

    danilo rodrigues da silva

      Bom dia, quero gerar um qvd a partir da união de outros dois, ou seja quero unir dois qvds em uma única base, queria saber se é possível e como devo proceder, olhem me script:

       

       

      [Req]:

      Buffer LOAD

      [REQUEST_NUMBER] AS [REQUEST_NUMBER-SRID],

      [SRD_NUMBER],

      [SITE] AS [Req.SITE],

      [STATUS] AS [Req.STATUS],

      [REGION],

      [TITLEFROMSRD],

      [CUSTOMER_FULL_NAME],

      [CLOSED_DATE],

      [CUSTOMER_ORGANIZATION]

      FROM [lib://Buffers/Req.qvd]

      (qvd);

       

       

      [wo]:

      Buffer LOAD

      [SRID] AS [REQUEST_NUMBER-SRID],

      [WORK_ORDER_ID],

      [ASGRP],

      [GSC_DTMDATAFECHAMENTO],

      [GSC_CIDADEUNIDADE],

      [SITE] AS [wo.SITE],

      [WOI_JUSTIFICATIVACANCELAMENTO],

      [ASORG],

      [SITE_GROUP],

      [GSC_UFUNIDADE],

      [ASCPY],

      [SUMMARY],

      [STATUS] AS [wo.STATUS],

      [STATUS_REASON],

      [SUBMIT_DATE],

      [ACTUAL_START_DATE],

      [VENDOR_TICKET_NUMBER],

      [ACTUAL_END_DATE],

      [COMPLETED_DATE],

      [PRODUCT_CAT_TIER_3__2_],

      [GSC_CEP]

      FROM [lib://Buffers/wo.qvd]

      (qvd);

        • Re: Geração de um QVD a partir de outros 2
          Erich Shiino

          Olá,

          Use o concatenate()

           

          [Req]:

          Buffer LOAD

          [REQUEST_NUMBER] AS [REQUEST_NUMBER-SRID],

          [SRD_NUMBER],

          [SITE] AS [Req.SITE],

          [STATUS] AS [Req.STATUS],

          [REGION],

          [TITLEFROMSRD],

          [CUSTOMER_FULL_NAME],

          [CLOSED_DATE],

          [CUSTOMER_ORGANIZATION]

          FROM [lib://Buffers/Req.qvd]

          (qvd);

           

           

          concatenate (Req)

          Buffer LOAD

          [SRID] AS [REQUEST_NUMBER-SRID],

          [WORK_ORDER_ID],

          [ASGRP],

          [GSC_DTMDATAFECHAMENTO],

          [GSC_CIDADEUNIDADE],

          [SITE] AS [wo.SITE],

          [WOI_JUSTIFICATIVACANCELAMENTO],

          [ASORG],

          [SITE_GROUP],

          [GSC_UFUNIDADE],

          [ASCPY],

          [SUMMARY],

          [STATUS] AS [wo.STATUS],

          [STATUS_REASON],

          [SUBMIT_DATE],

          [ACTUAL_START_DATE],

          [VENDOR_TICKET_NUMBER],

          [ACTUAL_END_DATE],

          [COMPLETED_DATE],

          [PRODUCT_CAT_TIER_3__2_],

          [GSC_CEP]

          FROM [lib://Buffers/wo.qvd]

          (qvd);

           

          Abs,

          Erich