7 Replies Latest reply: Apr 24, 2018 6:17 PM by Will Schefter RSS

    Trouble loading data

    Will Schefter

      Hi all;

      I am trying very unsuccessfully to load data into Qlik Sense.  There are 7 tabs of data I am trying to load and only 5 ever load.  Each time I try to create the app the 5 that load are totally random.  I have tried creating this through both drag/drop and writing a script.  It does not matter which I do, only 5 load up.  I can create a separate app for the tabs but they just won't load all together.

       

      Overall there are 86 total columns that I'm trying to load.

       

      Any ideas as to what is wrong?  Here are the names of the tabs:

       

      Plant 1010_1010 Shipments

      Plant 1000_1010 Receipts

      Plant 1000_1010 Misc Trans

      Plant 1000_1010 SP&R Trans

      Transfer Orders

      Plant Storage Map

      Shipment To_From Location

       

      Thanks in advance for advice.

       

      Thanks.

        • Re: Trouble loading data
          Krishna Nagulapally

          can you provide the qvf?

            • Re: Trouble loading data
              Will Schefter

              Hi Krishna;

              I should have thought of that to start with...I have loaded to the original post.

               

              Thanks.

                • Re: Trouble loading data
                  Krishna Nagulapally

                  Will -  i dont see any data or script in the qvf attached. i just see a connection but thats your local path from where i cant load any data.

                   

                  Do this - load data from your local , save it and send that to me.then i can see the script atleast.

                    • Re: Trouble loading data
                      Will Schefter

                      Would it be wrong of me to say that apparently I am not totally here today?  Sheesh...

                       

                      I have loaded both version I have of the app.  The first, titled ASM Phoenix Warehouse is app that I loaded the data through a script.  The second, ASM Phoenix Warehouse1, was the drag/drop app.

                       

                      I am sorry for making this difficult today.

                       

                      thanks.

                      Will

                        • Re: Trouble loading data
                          Krishna Nagulapally

                          Qualify *;


                          Table1:

                          LOAD

                              "Shipment To/From Location",

                              City,

                              Country

                          FROM [lib://ASM Phoenix Warehouse Data/ASMA Warehouse World Maps.xlsx]

                          (ooxml, embedded labels, table is [Shipment To_From Location]);


                          Table2:

                          LOAD

                              Plant,

                              "Storage Location",

                              Vendor,

                              "Purchase Order",

                              Item,

                              Material,

                              "Material Description",

                              "Qty in Un. of Entry",

                              "Unit of Entry",

                              "WBS Element",

                              "Movement Type",

                              "Amount in LC",

                              Currency,

                              "Posting Date",

                              "User Name"

                          FROM [lib://ASM Phoenix Warehouse Data/Plant 1000_1010 Misc Transactions.xlsx]

                          (ooxml, embedded labels, table is [Plant 1000_1010 Misc Trans]);



                          NoConcatenate

                          //previously this table was getting appended to the previously loaded table as they both have same number of fields with same field names//

                          //Noconcatenate - this keyword forces the table not get appended automatically//

                          Table3:

                          LOAD

                              Plant,

                              "Storage Location",

                              Vendor,

                              "Purchase Order",

                              Item,

                              Material,

                              "Material Description",

                              "Qty in Un. of Entry",

                              "Unit of Entry",

                              "WBS Element",

                              "Movement Type",

                              "Amount in LC",

                              Currency,

                              "Posting Date",

                              "User Name"

                          FROM [lib://ASM Phoenix Warehouse Data/Plant 1000_1010 Receipts.xlsx]

                          (ooxml, embedded labels, table is [Plant 1000_1010 Receipts]);


                          Table4:

                          LOAD

                              Delivery,

                              "Ship-to party",

                              "Name of the ship-to party",

                              "Picking Date",

                              "Transptn Plang Date",

                              "Goods Issue Date",

                              "Deliv. date(From/to)",

                              Plant,

                              "Warehouse Number",

                              "Delivery Priority",

                              "Shipping Point/Receiving Pt",

                              "Number of packages",

                              "Total Weight"

                          FROM [lib://ASM Phoenix Warehouse Data/Plant 1000_1010 Shipments.xlsx]

                          (ooxml, embedded labels, table is [Plant 1000_1010 Shipments]);


                          Table5:

                          NoConcatenate

                          //previously this table was getting appended to the previously loaded table as they both have same number of fields with same field names//

                          //Noconcatenate - this keyword forces the table not get appended automatically//

                          LOAD

                              Plant,

                              "Storage Location",

                              Vendor,

                              "Purchase Order",

                              Item,

                              Material,

                              "Material Description",

                              "Qty in Un. of Entry",

                              "Unit of Entry",

                              "WBS Element",

                              "Movement Type",

                              "Amount in LC",

                              Currency,

                              "Posting Date",

                              "User Name"

                          FROM [lib://ASM Phoenix Warehouse Data/Plant 1000_1010 SP&R Transactions.xlsx]

                          (ooxml, embedded labels, table is [Plant 1000_1010 SP&R Trans]);



                          Table6:

                          LOAD

                              "Transfer Order Number",

                              "Transfer order item",

                              "Requirement Number",

                              Material,

                              "Stock Category",

                              "Special Stock",

                              "Source Storage Type",

                              "Source Storage Bin",

                              "Source target qty",

                              "Alternative Unit of Measure",

                              "Confirmation type",

                              "Confirmation status",

                              "Dest. Storage Type",

                              "Dest.Storage Bin",

                              "Requirement Type",

                              "Movement Type",

                              "Creation Date",

                              "User Name",

                              "Confirmation status source/dest.",

                              "Confirmation date",

                              "User Name1",

                              "Material Doc.Item"

                          FROM [lib://ASM Phoenix Warehouse Data/Plant 1000_1010 Transfer Orders.xlsx]

                          (ooxml, embedded labels, table is [Transfer Orders]);


                          Table7:

                          LOAD

                              Plant,

                              "Storage Location",

                              Name

                          FROM [lib://ASM Phoenix Warehouse Data/Plant Storage Map.xlsx]

                          (ooxml, embedded labels, table is [Plant Storage Map]);


                          Unqualify *;

                          • Re: Trouble loading data
                            Krishna Nagulapally

                            Copy paste the script below and run the app and let me know.

                             

                            Make sure to add the keywor 'NoConcatenate'  above all the tables where you have common/similar/same filed name,

                            else they get appended to the previoulsy loaded tables that has same field names.