How to load these records too?

[hcabrera]

Hi All,

I have 2 tables that are related by date field and product code, I created a master calendar, the idea is to get a table containing all of the 2 tables guided by the date of the master calendar like this in the attachment.

any comments thank you.

Henry C.

[hareeshkumar_gv]

Hi Henry,

Could you please clarify that you need to create one table(as mentions in attached xls file) or do you need to split the tables??

[hcabrera]

thanks for answering hareesh,

the goal is to build a pivot table that has 2 missing records listed in the attachment.

[maxgro]

I used the excel

PROGRAMA:

First 8

LOAD Fecha,

     NroPrograma,

     CodProducto,

     [Des Producto],

     [Cantidad Producida]

FROM

data_program.xlsx

(ooxml, embedded labels, header is 1 lines, table is Hoja1);

join (PROGRAMA)

First 6

LOAD

  //date(date#(Fecha1, 'DD/MMM/YYYY')) as Fecha,

  Fecha1 as Fecha,

     Linea,

     CodProducto1 as CodProducto,

     [Des Producto1] as [Des Producto],

     Formato,

     [Cant Entregada]

FROM

data_program.xlsx

(ooxml, embedded labels, header is 1 lines, table is Hoja1);