Excel Reader Transformations - Can't make integer a string?

Hi!
Why can I take a string column and make it an integer, but I can’t take an integer column and make it a string? This is within the Excel Reader transformations tab:

Hi @Snowy -

This is certainly counter-intuitive, isn’t it? Fortunately we have a ticket to address this issue (AP-16030), so this and some other transformation idiosyncracies should be fixed in a future release. I’ve added a +1 from you on that ticket. Sorry for the trouble!

2 Likes