Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 *;
can you provide the qvf?
Hi Krishna;
I should have thought of that to start with...I have loaded to the original post.
Thanks.
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.
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
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 *;
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.
Thank you very much. I really appreciate the help. Have a good day.
Will