SQLLOADER not loading correct value from csv? Please help.

User_AS6XD

Issue: Rank column of target table is loaded with 'Yes' value instead of numbers and character values in excel? Why?

Please find attached excel sheet from which i am loading data using TOAD SQLLOADER Wizard

CTE BR Upload consolidated.xlsx

Data_control.ctl.txt

Data_control.ctl is the control file.

Now Rank column of excel is having both numbers and characters stored as text,using sqlloader i am loading it into target table crr_stg

Table script:

CREATE TABLE ERDCRM.CRR_STG

(

 ES100     VARCHAR2(100 BYTE),

 REGION     VARCHAR2(100 BYTE),

 REVIEW_PERIOD VARCHAR2(100 BYTE),

 REVIEW_TYPE  VARCHAR2(100 BYTE),

 RANK      NVARCHAR2(20)

)

Kindly help.

EdStevens

No one in their right mind is going to open a link to an Excel or Word document, from some stranger on the internet. That's a major source of 'infected' autoexecute macros.

In fact, many people here refuse to open any link, regardless of the file type. You should post your csv ( or a representative extract from it) _as text_ in your message. Same for the control file.

And any posted code and data should be formatted as such, as per https://community.oracle.com/tech/apps-infra/kb/articles/12-format-text