topic Re: Trouble loading data in App Development

Trouble loading data

wschefter — Tue, 24 Apr 2018 19:58:21 GMT

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

Qrishna — Tue, 24 Apr 2018 20:17:24 GMT

can you provide the qvf?

Re: Trouble loading data

wschefter — Tue, 24 Apr 2018 20:31:18 GMT

Hi Krishna;

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

Thanks.

Re: Trouble loading data

Qrishna — Tue, 24 Apr 2018 20:37:51 GMT

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

wschefter — Tue, 24 Apr 2018 21:07:59 GMT

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

Qrishna — Tue, 24 Apr 2018 21:22:07 GMT

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

Qrishna — Tue, 24 Apr 2018 21:24:00 GMT

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.

Re: Trouble loading data

wschefter — Tue, 24 Apr 2018 22:17:07 GMT

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

Will