load script issue

[bushpalaamarnat]

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)))

));

[vishsaggi]

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]

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]

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?

[bushpalaamarnat]

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]

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?