This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 69%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EES%3C/text%3E%3C/svg%3E)
Hello, I have a txt file with several columns, and there is no delimiter. We find the columns by index (position). How can I read this file from a data factory and copy the contents into a table with several columns Thanks,
Can you please provide a screenshot of your file? Or upload the sample file
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
@Emilio Salas Roura Following up to see if the below suggestion was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 12%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Hi, you may go through this link, where there's a detailed information to process fixed length files. https://learn.microsoft.com/en-us/azure/data-factory/how-to-fixed-width If your requirement is different, as Nandan has requested, please share a sample file with details. Thanks.
Yes, that's exactly what I'm trying to do. But when I want to test this example I had this error.
Importing the projection. Where can I see the error details (view notification)
You can go to monitor tab and see the details of the execution. Please see if you are able to import schema in the dataset. And then you can come to data flow and import projection. Please try and let us know.
I cannot go to monitor because I'm trying to setup the projection and I got that error without any description. I cannot save this pipeline in order to run or debug
Hi, You are right, without running, we cannot go to monitor. As mentioned in my earlier comment, please do a schema import from data set and then come to data flow to import projection. This way, you can catch any issues with the dataset. And, you can delete the data flow source and add freshly. (after schema import from dataset). If the data flow fails due to intermittent network issue, this might resolve the issue too. Generally, If there are no proper details in the error, it might be due to improper configuration \ expressions in the source. Please post screenshots of source settings and source option tabs of your dataflow along with the dataset settings.
Hi, importing previously the schema in dataset, the import projection has worked. Please, See screenshot
But I had an error in data preview
The delimitor should by \n by default thanks,
@Emilio Salas Roura It's great to hear that the import projection has worked after importing the schema in the dataset. Regarding the error in data preview, it seems like the delimiter is not set correctly. You can change the delimiter to \n by following these steps:
\n.Please let me know if this resolves the issue.
Hello @Emilio Salas Roura
To read a text file with several columns and no delimiter, you can use the Custom delimited format in the Azure Data Factory. In this case, you can specify the column widths as the delimiter.
Here are the steps to do this:
Azure Blob Storage connector as the source. File path field. Format section, select Custom delimited as the format. Column delimiter field, specify the column widths as the delimiter. For example, if your first column is 10 characters wide and your second column is 5 characters wide, you would specify "10,5" as the delimiter. Schema section, specify the column names and data types for each column in your text file. Azure SQL Database connector as the sink. Mapping section, map the columns from your source dataset to the columns in your destination table. Once you have created both datasets, you can create a pipeline to copy the data from your source dataset to your destination dataset using the Copy Data activity. In the Copy Data activity, select your source and destination datasets and specify any additional settings, such as the frequency of the copy operation. I hope this helps! Let me know if you have any further questions.