3 Replies Latest reply: Nov 27, 2012 12:17 PM by Brian Garside RSS

    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;

        • Re: Inner Keep wont store data...
          sree anaarasi

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

              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...
                  marco masin

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