Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Excel data load, multiple tabs

Hi All,

Wonder if you could help me please as I am struggling with an excel dataload, am sure this is basic stuff but can't figure it out!

When I run the three seperate loads individually they work perfectly well however when I run them together they fetch the correct row count but then hang and force me to terminate the application as it freezes every time?

In this example I have commented out the third load to simplify things but surely that should also work if uncommented as they all have a common field?

Note tab 1 is called Opening and tab 2 is called closing - thanks in advance.

SET

ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='£#,##0.00;-£#,##0.00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';


LOAD * FROM



(
ooxml, embedded labels, table is Opening);

LOAD * FROM



(
ooxml, embedded labels, table is Closing);


//LOAD [DWF Ref],

//     [Date Instructions Received],

//     [Amount of Insured Damages Recovered],

//     [Date Closed],

//     if([Amount of Insured Damages Recovered]>=0,1,0)

//

//FROM

//

//(ooxml, embedded labels, table is Closing)

1 Solution

Accepted Solutions
Not applicable
Author

paste

qualify *;

before first load

if works fine send us printscreen of structure from tableview

View solution in original post

11 Replies
sreenivas
Creator III
Creator III

Can you add the excel files data too

Jason_Michaelides
Luminary Alumni
Luminary Alumni

Try naming your tables by adding TableName: before the LOAD and give your If() statement an alias using AS RecoveredFlag

Hope this helps,

Jason

Not applicable
Author

Can you add the excel files data too -

Sorry I don't understand your question?

sreenivas
Creator III
Creator III

Add the excel files which you are refering

Not applicable
Author

Thanks Jason,

Apologies as I am new to this, what is the correct syntax for table name before the load?

Thanks

Not applicable
Author

I can add the excel file in a single data load as specified but can't add the tabs in a multiple load

Not applicable
Author

Jason,

I have changed the code to the following and it is still freezing?;

SET

ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='£#,##0.00;-£#,##0.00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

TableOpening:
LOAD * FROM



(
ooxml, embedded labels, table is Opening);

TableClosing:

LOAD * FROM



(
ooxml, embedded labels, table is Closing);


//LOAD [DWF Ref],

//     [Date Instructions Received],

//     [Amount of Insured Damages Recovered],

//     [Date Closed],

//     if([Amount of Insured Damages Recovered]>=0,1,0) a
s 'No. of Cases Closed with Recovery'



//

//FROM

//

//(ooxml, embedded labels, table is Closing)

sreenivas
Creator III
Creator III

Goto-->Editscript and debug the code using step by step

I think it is having the same column names in both the tables it may cause the syn tables and break the operation.

In Tableclosing and TableOpening add all the column names instead of "*" and post that script

Not applicable
Author

paste

qualify *;

before first load

if works fine send us printscreen of structure from tableview

View solution in original post