Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Inner Keep wont store data...

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;

1 Solution

Accepted Solutions
Not applicable

Re: Inner Keep wont store data...

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

3 Replies
shree909
Valued Contributor II

Re: Inner Keep wont store data...

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

Not applicable

Re: Inner Keep wont store data...

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.

Not applicable

Re: Inner Keep wont store data...

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

Community Browser