Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bushpalaamarnat
Creator
Creator

load script issue

Hi All,

Could any one please help, in the excel we have number's with out decimal and in the loadscript, the data is converting into 123.0000, that is 4 decimal place number.

Can this be done anything in the load script level.

My script is

AllFile:

LOAD *

FROM

[\\uk2dsntv001.corpnet2.com\GMS_SCLDesign\Work In Progress\Respiratory\Neelima Bushpala-BPS\Work Package\Inventory Corridor Dashboard\Data\Files for load\*.xlsx]

(ooxml, embedded labels, filters(

Remove(Row, RowCnd(CellValue, 1, StrCnd(null)))

));

Capture.PNG

5 Replies
vishsaggi
Champion III
Champion III

Did you check your environment variables in Qlikview when you open QV. Like in below:

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

Can you share your excel if possible?

bushpalaamarnat
Creator
Creator
Author

the excel is set as follows

Hi, please find attached excel information. Also, the default set is as it is did not make any changes.

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

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

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

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';

SET FirstWeekDay=6;

SET BrokenWeeks=1;

SET ReferenceDay=0;

SET FirstMonthOfYear=1;

SET CollationLocale='en-US';

vishsaggi
Champion III
Champion III

Did you load the data as is after your File Transform wizard. It looks ok to me. This is what i see when i load your excel?

Capture.PNG

bushpalaamarnat
Creator
Creator
Author

AllFile:

LOAD *

FROM

[\\uk2dsntv001.corpnet2.com\GMS_SCLDesign\Work In Progress\Respiratory\Neelima Bushpala-BPS\Work Package\Inventory Corridor Dashboard\Data\Files for load\*.xlsx]

(ooxml, embedded labels, filters(

Remove(Row, RowCnd(CellValue, 1, StrCnd(null)))

));

this is the script, as it is no changes.

vishsaggi
Champion III
Champion III

Oh you are using multiple excel sheets? Does all the other excel data in same format or different? Can you share your qvw file where you loaded these excel files and what is that your expected output should be?