Using Azure Data Factory Dataflow with csvs using ";" as a separator

Question

I'm new to DataFlow in ADF.

I have a dataset that correctly handles the fact that the column delimiter is the ";" character :

The "preview data" option in the Dataset shows me that the CSVs is parsed appropriately, and splits the columns as intended.

Connecting to this dataset as a source in DataFlow, it seems to disregard the Dataset configuration :

and will only have only 1 column. I know I can parse it again, but I would loose all the convenience provided by DataFlow...

How can this be handled ?

Answer 1

Hi @Etienne de Villers ,

Welcome to Microsoft Q&A platform and thanks for posting your question here.

As I understand your query, you have source data which is delimited by semi colon , even after selecting 'column delimiter' as 'semicolon(;)' , you are still seeing single column in the data preview. Please let me know if my understanding is incorrect.

Kindly make sure that after selecting 'semicolon' as column delimiter , you are importing schema in the source dataset.

If it doesn't work, kindly try importing projection in projection tab before checking the data preview. Here is the reference video:

Hope this will help. Please do consider clicking Accept Answer and Up-Vote for the same as accepted answers help community as well