Skip to Content
avatar image
Former Member

Loading Excel data with custom format applied

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Sep 09, 2014 at 05:09 PM

    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,

    Add comment
    10|10000 characters needed characters exceeded