column result is not displaying in output

Attached is a sample1.xls file for testing purpose on your end. But on my end I see this happening with the same column but I am hoping it can be reproduced on your end.

If you create the sample1.xls file as the source and have this same file to be outputted with the same columns with no validations or transformation set, other than mapping the columns the same to the output file, my Revenue Data Month column is not outputting the data. It is coming up blank.

Can you find out what is going on, this has me stumped?

I appreciate it. Thanks.

If you look very carefully you will see spaces at the beginning and at the end of the field

Remove them and it will work

Thank you so much. I am not sure how those extra spaces got in there as I used the source as the template for the output headers and I assumed the mapping would pick up and match that space.

I did see I had a trailing space in my output file, removed it and recreated the output writer but for some reason that space kept being added. Very weird.

I didnt know I can manually edit from that view. Thanks for the tip. So much too learn.

Have a great day.