Preserve formatting in excel data import

[Daniel Plunket1]

I have a question related to importing data from an excel spreadsheet. I'm trying to upload data into a table and the formatting of the text in one of the columns is something I'd like to preserve. After it goes through the transform map, that formatting is completely destroyed. Is there a way I can keep the formatting after the data gets transformed. 

[Arpan Baishya]

Hi @Daniel Plunket1,

I'll take a stab at answering this. I think it might be possible to preserve certain formatting styles such as currency, date/time, etc after transforming the import data to the target table. I'm not sure which formatting style you are referring to in your question, however, it might be safe to say that not all types of Excel-based formatting can be retained post transform.