I don't know if someone will be able to solve my problem but let's try it anyway.
Here is my situation :
- I have an automation that contains a filter activity (step 1), a data extract activity (step 2) and a file transfer activit (step 3).
- The automation is working perfectly fine, file is correctly transfered to Marketing Cloud SFTP.
My problem is the following: when I open the CSV file downloaded from Marketing Cloud SFTP, data for one record is displayed on two different rows and I can't find a way to format it. I don't know if the problem comes from Marketing Cloud or not.
Here is how my data is displayed
Here is how my data should be displayed
UPDATE: I found the source of the problem. In Sales Cloud, data for the field "Address" contains a line break. Therefore, there is a line break in my DE and that is why data is displayed on two separate rows in CSV file.