Data Transfer component transfers csv with more rows than initial table

Matillion ETL
1

Hi guys, please help me out since this thing seems impossible.

I have a File Iterator that connects via SFTP to the folder containing the file of interest. I use the Filter Regex to extract that file. Then I use a Data Transfer component to upload it to Azure Blob.

Even though the uploaded csv file has the exact same size as the original one, the number of rows is different:

0694G00000USBNsQAP_0D54G00009bUgkASAS

 

In the image above the former one is manually downloaded from SFTP and the letter is downloaded from Blob after it was uploaded using Matillion.

0694G00000USBPjQAP_0D54G00009bUgkASAS
0694G00000USBPjQAP_0D54G00009bUgkASAS1297×718 45.4 KB

0694G00000USBPMQA5_0D54G00009bUgkASAS
0694G00000USBPMQA5_0D54G00009bUgkASAS1327×763 47.9 KB

 

Please guide me through this process in order to figure it out how to solve it. Thank you!

2

Just because occasionally Excel does weird things. If you open the files in notepad++ (or another text editor of your choice with line numbers) do they also show different numbers of lines?

 

Are all the rows the same width? E.g. has there been some kind of cr&lf issue and some rows are actually 2 rows jammed together?

3

Indeed the issue was with the way Excel opened the file. Thank you!