I would like to import numeric columns from CSV file in custom format. One column has "#N/A" when value is not available, while other contains percentages and have "%" at the end.
Go to Solution.
So datatype in the CSV schema must be string and you have to convert by yourself.
I was afraid that somebody would say that Thank you! I did it with mapper and some custom routines.
Can you please post the customization mapping so it will be helpful for others.