topic Inner Keep wont store data... in QlikView

Inner Keep wont store data...

Tue, 27 Nov 2012 16:30:53 GMT

I have a Script that does an Inner Keep join on two Excel sheets.

My problem is after its complete it shows no data but you can see the table in the table viewer but no data.

I think I may have a memory issue. It only has 6800 & 1400 lines each. See attached Screen shot. I cant preview the data

Please help!

My script is below;

Directory;

Master_TAMCN:

Directory;

LOAD TAMCN,

[Colloquial Name],

[Item Name],

[Cargo Category Code Type],

[Cargo Category Code],

[Cargo Category Type of Container],

[Climate Control],

[Dimensional Data Certification Indicator],

[Dimensional Category],

[Mobile Load Indicator],

[Shipping Configuration Code],

[Square Stowage Indicator],

[Dimension: Height in Centimeters],

[Dimension: Height in Feet],

[Dimension: Height in Inches],

[Dimension: Length in Centimeters],

[Dimension: Length in Feet],

[Dimension: Length in Inches],

[Dimension: Lowest Reducible Height in Centimeters],

[Dimension: Lowest Reducible Height in Feet],

[Dimension: Lowest Reducible Height in Inches],

[Dimension: Standard Package Cube],

[Dimension: Standard Package Square],

[Dimension: Standard Package Weight Kilograms],

[Dimension: Standard Package Weight Pounds],

[Dimension: Width in Centimeters],

[Dimension: Width in Feet],

[Dimension: Width in Inches]

FROM

Master_TAM_Combined.xlsx

(ooxml, embedded labels, table is Combined);

MCPP_N:

LOAD TAMCN as TAMCN, // Join Key

Nomenclature as NOMENCLATURE_MCPP

// [MEB REQ],

// [2012 PO],

// REQ,

// PO,

// REQ1,

// PO1,

// REQ2,

// PO2,

// REQ3,

// PO3,

// [REQ x3],

// #1,

// #2,

// #3,

// FOOD,

// FUEL,

// HAB,

// [A&A],

// WATER,

// ESCAL,

// [M/CW],

// R2C,

// CBRN,

// MT,

// ENG,

// SECURITY,

// ELECTRICAL,

// MED,

// [Sub-Total],

// F32,

// [MEB Augm],

// TOTAL,

// [Tailoring Comments],

// [T/E],

// Ship,

// Unf,

// PP,

// [MEB REQ1],

// [2012 PO1],

// [2013 PO],

// Remarks,

// [Associated End Items],

// [SL3 End Items],

// Notes,

// F47,

// Remarks1

FROM

[MFE MCPP_N AdaptForcePackages Merge 3.1.xlsx]

(ooxml, embedded labels, table is MCPP_N_PO_Development_Worksheet);

Inner Keep (Master_TAMCN)

LOAD * Resident MCPP_N;

Drop Table MCPP_N;

Re: Inner Keep wont store data...

shree909 — Tue, 27 Nov 2012 16:46:10 GMT

i think u need to get rid of directory; for table Master_TAMCN and then reload the application..

instead of inner keep try inner join

Re: Inner Keep wont store data...

Tue, 27 Nov 2012 17:17:22 GMT

Did get it to work once but not the second time, but I did remove the Dir statement.

It must be my script. I know joins take more memory, but this is strange.

Re: Inner Keep wont store data...

Tue, 27 Nov 2012 17:22:00 GMT

Master_TAMCN:

Directory;

LOAD TAMCN,

[Colloquial Name],

[Item Name],

[Cargo Category Code Type],

[Cargo Category Code],

[Cargo Category Type of Container],

[Climate Control],

[Dimensional Data Certification Indicator],

[Dimensional Category],

[Mobile Load Indicator],

[Shipping Configuration Code],

[Square Stowage Indicator],

[Dimension: Height in Centimeters],

[Dimension: Height in Feet],

[Dimension: Height in Inches],

[Dimension: Length in Centimeters],

[Dimension: Length in Feet],

[Dimension: Length in Inches],

[Dimension: Lowest Reducible Height in Centimeters],

[Dimension: Lowest Reducible Height in Feet],

[Dimension: Lowest Reducible Height in Inches],

[Dimension: Standard Package Cube],

[Dimension: Standard Package Square],

[Dimension: Standard Package Weight Kilograms],

[Dimension: Standard Package Weight Pounds],

[Dimension: Width in Centimeters],

[Dimension: Width in Feet],

[Dimension: Width in Inches]

FROM

Master_TAM_Combined.xlsx

(ooxml, embedded labels, table is Combined);

MCPP_N:

inner keep(Master_TAMCN)

LOAD TAMCN as TAMCN, // Join Key

Nomenclature as NOMENCLATURE_MCPP

// [MEB REQ],

// [2012 PO],

// REQ,

// PO,

// REQ1,

// PO1,

// REQ2,

// PO2,

// REQ3,

// PO3,

// [REQ x3],

// #1,

// #2,

// #3,

// FOOD,

// FUEL,

// HAB,

// [A&A],

// WATER,

// ESCAL,

// [M/CW],

// R2C,

// CBRN,

// MT,

// ENG,

// SECURITY,

// ELECTRICAL,

// MED,

// [Sub-Total],

// F32,

// [MEB Augm],

// TOTAL,

// [Tailoring Comments],

// [T/E],

// Ship,

// Unf,

// PP,

// [MEB REQ1],

// [2012 PO1],

// [2013 PO],

// Remarks,

// [Associated End Items],

// [SL3 End Items],

// Notes,

// F47,

// Remarks1

FROM

[MFE MCPP_N AdaptForcePackages Merge 3.1.xlsx]

(ooxml, embedded labels, table is MCPP_N_PO_Development_Worksheet);