Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
wschefter
New Contributor II

Trouble loading data

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.

1 Solution

Accepted Solutions
krishna_2644
Valued Contributor III

Re: Trouble loading data

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

View solution in original post

7 Replies
krishna_2644
Valued Contributor III

Re: Trouble loading data

can you provide the qvf?

wschefter
New Contributor II

Re: Trouble loading data

Hi Krishna;

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

Thanks.

krishna_2644
Valued Contributor III

Re: Trouble loading data

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.

wschefter
New Contributor II

Re: Trouble loading data

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

krishna_2644
Valued Contributor III

Re: Trouble loading data

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

View solution in original post

Highlighted
krishna_2644
Valued Contributor III

Re: Trouble loading data

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.

wschefter
New Contributor II

Re: Trouble loading data

Thank you very much.  I really appreciate the help.  Have a good day. 

Will