cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member187605
Active Contributor
0 Kudos

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.