Azure Data Factory V2 - Importing TSV files with different decimal sign


  • Hi, I'm trying to figure out how to copy floating point numbers with a different decimal separator ("," instead of ".") from a data lake file. Currently the sign will be ignored and wrong values are importet.

    Is there a solution or workaround?

    • Edited by ThomasW_ Tuesday, June 5, 2018 9:30 AM
    Tuesday, June 5, 2018 9:26 AM

All replies

  • From your description, I assume the field is currently of type string in data lake.

    I think the you could do the below:

    1. You can copy the field as a string from data lake source.

    2. In the transformation step, using data lake analytics, Replace ',' with '.' and convert the string to decimal.

    3. Then store it in the sink

    Tuesday, June 5, 2018 10:15 PM