Data type mismatch error while loading data from file | Community
Skip to main content
alwaysDigital
alwaysDigital
Level 2
April 10, 2018
Solved

Data type mismatch error while loading data from file

  • April 10, 2018
  • 2 replies
  • 2673 views

Dear all,

I am facing issue while loading data from file. The issue is -

writer   WKF-560065 the type of the 'gender' expression (type: string) does not match the type of the '@gender' destination field (type: byte)

At this moment I have changed(Byte -> String) data type for gender attribute in extended schema and its working fine. Is this right approch? Kindly let me know.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by arouillard44

Hello AlwaysDigital,

If you want that your 2 fields match, you have to change one side, yes.

In my opinion, you should better change the field type from your file (in you Data Loader Activity), and not change the native gender field. That could work, but you can encounter some type issue in some case after.

Hope I Helped,

Regards,

2 replies

arouillard44
arouillard44Accepted solution
Level 4
April 10, 2018

Hello AlwaysDigital,

If you want that your 2 fields match, you have to change one side, yes.

In my opinion, you should better change the field type from your file (in you Data Loader Activity), and not change the native gender field. That could work, but you can encounter some type issue in some case after.

Hope I Helped,

Regards,

alwaysDigital
alwaysDigitalAuthor
Level 2
April 10, 2018

Hello Arouillard44,

Thanks for quick response. Yes we change from data file as well.

Terms & ConditionsAccessibility statement

Loading footer...