I have a xml file where few fields available which is basically Boolean data type and value given as like "Y" and "N". Now I am trying to develop the mapping and during that used flatten and when trying to see data preview for those Boolean field its showing value different way like attached screenshot .Could you please have a look and let me know why it's coming that way.


