Loading Excel data with custom format applied

[Former Member]

Hi,

I have an Excel File as source with the custom formatting applied to the data in it.

For Eg. value 64 has special formatting applied so as to display it as 0064.

BODS loads only the actual data as 64 and though I expect to load the formatted data(0064).

Is this an expected behavior of BODS?

DS Version : 14.1.2

Thanks.

[pan_cheng]

No. If you define file format as flat file and define the field type as char then you can load all the formatted data like 0064 into DB. If you use excel then excel will remove leading zeros. This is excel functionality. or you can define the input file as CSV file and change the format of the field.

Thanks,

[Former Member]

Flat files as csv or.txt work as expected. The source is. Xlsx.

We can't alter the source files or their file formats.