How to disable auto detect datatype in azure data flow-CodePudding

I was working on a XML file in ADF and there is a field that is having 42 integer digits. I want it to be reflected as it is in azure data flow so that I could perform some transformations There is a checkbox "Detect Data Type" in copy data activity which when unchecked provides the exact value. but when using the dataflow, it is not giving any option to not to perform auto detect data type . kindly suggest what need to be done

    <?xml version="1.0" encoding="UTF-8"?>
   <start>
       <name>ABC</name>
       <id>123456789098765432123456789098765432123456</id>
   </start>

CodePudding user response：

Import projection from the Projection tab is used to Import schema and detect data types from the source. If you just don't click it or use this, your data columns will be of type string.

Here is an example:

Source XML:

Import projections:

You can see the column id is inferred as type Double

While if you just don't use Import projection option, and Reset Schema

you get the column id as type String

For further details, refer official MS doc on ADF Dataflow Projections