Skip to Content
avatar image
Former Member

DS sets the character data as when the excle conlum includes number data and character data

For example:

i want to upload data which from excle file as follows,

column1 column2

1 2

1 2

1 2

1 2

1 2

1 2

1 2

1 2

a 2

a 2

a 2

DS will set ‘a’ as <null> when is view the data from excle source.

Please tell me how to solve this.Thanks very much

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 07, 2016 at 02:27 PM

    All depends on the Excel file format defined. If the first column is numeric, it will show null for alphabetic values.
    Specify a varchar datatype.

    Add comment
    10|10000 characters needed characters exceeded