question

ARUPDEBBURMAN-3046 avatar image
0 Votes"
ARUPDEBBURMAN-3046 asked KranthiPakala-MSFT commented

Facing issue in ADF Data Flow

I have a xml file where few fields available which is basically Boolean data type and value given as like "Y" and "N". Now I am trying to develop the mapping and during that used flatten and when trying to see data preview for those Boolean field its showing value different way like attached screenshot .Could you please have a look and let me know why it's coming that way.

azure-data-factory
· 7
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@ARUPDEBBURMAN-3046,

Please provide more details.

0 Votes 0 ·

I have source xml file which is contain one of the field called ISPAYMENT(Please refer the attached source file screenshot).

Now I am developing ADF data flow ....where I have used flatten which we are generally used for xml source files. Now I am trying to mapped aforesaid xml source and preview the data output using dat flow debug. I am getting ISPAYMENT field as well as other same kind of field which value showing Y OR N in xml structure which you can see in source file screenshot. But after using flatten I have seen value is showing as tick mark or cross mark as I have already given that screenshot. Now my query is why its showing as different compare to source file.

98835-source-file-screenshot.png


0 Votes 0 ·

In data preview, boolean values are represented in the UI as check for true, X for false.

0 Votes 0 ·

Hi @@ARUPDEBBURMAN-3046,

Thanks for reaching out. Just wanted to check if the above information from Mark Kromer answers your query? Do let us know if need further assistance? And also I haven't seen any screenshot attached in the original post about the data preview, please consider to add it for better understanding of the scenario.

Thank you

0 Votes 0 ·
Show more comments

Sorry Missed the attachment in previous 99869-capture-1.png99879-capture2.png


0 Votes 0 ·
capture-1.png (134.1 KiB)
capture2.png (104.4 KiB)

Hi @ARUPDEBBURMAN-3046 ,

Thanks for your response and glad to know you were unblocked with the initial issue. As this issue is different than the original query, we request you to please open a new thread so that the community can better visibility on this issue and will be able to assist better.

But looking at the data types and the error message it seems like you have complex data types and hence your sink data format should be JSON, AVRO, or Azure CosmosDB as they support complex data types. If you are still blocked please open a new thread with the error message, sample data and what is your expected sink.

Thank you

0 Votes 0 ·

0 Answers