Problème lors de la fusion de données

vinny38  wrote

printerlady  wrote

I'm experiencing almost the same problem [...]

I still get an error message that reads 'The selected data source has one or more empty field names. Please fix the file or select another file."

Hi Tia,

well it's not the same problem at all ^^ (You could even have opened a new thread)

Just like MW Design pointed it out, the error message means that you have an empty field in your header row (which is the first row, as you probably know).

Typically, it does mean that there are 2 (or more) consecutive separators in your header row.

Fastest solution is to open your CSV or TXT file in a text editor and to delete those unwanted separators.

Where do those separators come from? Well... there are quite a lot of possible answers, and they basically relates to Excel (or some other spreadsheet)

FYI, Excel makes the difference between "blank cell" and "empty cell"... That could be a reason.

Also, sometimes Excel acts kinda weird. For example: using the "Empty cell" button results to some sort of "ghost formatting". Cells are empty, blank but CSV exports as non-empty. Deleting cells solves it. I personally prefer to keep a clean Excel file instead of cleaning it afterwards in a text editor, but that's your call.

See below the illustration of this weird situation (imagine you want to get rid of 2 unwanted columns):

Edit:

Oh and also, this is also a very typical situation:

Hope that helps

Vinny

Bon en résumé,  tu as des tabulations en trop...

À plus