I have already got from you a brilliant formula that helps me to get rid-off double quotes when exporting dataset to CSV file. It works great. Thanks again.
if(not iserror(asnumber([Column])), asnumber([Column]), [Column])
Usually, I have to apply it to many columns in the transformation “modify column”. It has to be done for each column separately.
I am migrating a couple of databases so I am sure you can imagine how painful it would be to click this for every single column.
Do you have an idea how one can do it in a better way? Quicker or more elegant way rather than clicking the same thing for each column in the dataset.
Pop-up window were all columns can be modified at once would work well for me. Maybe there is a better way.
Hope it makes some sense. Don’t hesitate to ask me for more details.