Repeat Characters in Field

[madhubabum]

Hi experts

I am Having Code as field , I am added logic to field (To repeat the char )

When , i am stored the field values into Excel then i am not getting the repeated  char .

How we can achieve this one ?

I am attaching the Excel file , Application , Excel output

Thanks

Madhu

[avinashelite]

That's the default nature in excel , try like this

Text((repeat('0',9-len([Code])))&[Code]) as

in the script level you will get the desired output 

[avinashelite]

Code_Desc:

LOAD 

Text((repeat('0',9-len([Code])))&[Code]) as [Code]

FROM

Book2.xlsx

(ooxml, embedded labels, table is Sheet1);

store [Code_Desc] into Code.xls(txt);

[SreeniJD]

Its exporting correctly for me in excel with the same qvw application. Are you using old version of Excel?

Sreeni

[tresesco]

Help- >About QlikView, and then

Once this is set, try exporting then.