topic Re: How to load these records too? in QlikView

How to load these records too?

hcabrera — Fri, 26 Feb 2016 14:09:54 GMT

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.

Re: How to load these records too?

hareeshkumar_gv — Fri, 26 Feb 2016 17:36:39 GMT

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??

Re: How to load these records too?

hcabrera — Fri, 26 Feb 2016 18:07:34 GMT

thanks for answering hareesh,

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

Re: How to load these records too?

maxgro — Fri, 26 Feb 2016 19:07:57 GMT

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);