12 Replies Latest reply: Sep 6, 2012 10:47 AM by bharadwaj pavuluri RSS

    How can I avoid Sync in this example?

    Camilo Lund

      Hi, I´m loading two tables but I´m getting syn tables ¿How can I avoid this?

       

      LOAD [Local SAP],

           [Id SAP] as ID,

           [Departamento SAP] as Departamento,

           Month(Dia) as Mes,

           Year(Dia) as Año,

           Dia as Fecha,

           [Unidades Vendidas],

           [Venta Neta $]/1000000 as Venta,

           [Costo Venta $]/-1000000 as Costo

       

      FROM

      [C:\Ventas.qvd]

      (qvd);

       

       

      LOAD Fecha,

           id_local_int as ID,

           ID_Categoria,

           Venta/1000000 as VentaP,

           [Margen dia]/1000000 as MargenP,

           Month(Fecha) as Mes,

           Year(Dia) as Año,

      FROM

      [C:\PptoDetalle.qvd]

      (qvd);

       

      Thanks!