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

Data type mismatch error while loading data from file

  • April 10, 2018
  • 2 replies
  • 2670 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

alwaysDigital
New Participant
April 10, 2018

Hello Arouillard44,

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

arouillard44
arouillard44Accepted solution
New Participant
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,