Expand my Community achievements bar.

SOLVED

Data type mismatch error while loading data from file

Avatar

Level 2

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)

datatype error.jpg

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.

Gender_datatpe.jpg

1 Accepted Solution

Avatar

Correct answer by
Level 4

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,

View solution in original post

2 Replies

Avatar

Correct answer by
Level 4

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,

Avatar

Level 2

Hello Arouillard44,

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