Only the “File Origin” dropdown appears, while the “Delimiter” and “Data Type Detection” dropdowns will not be shown. If you attempt to load a text file with differing quantities of data fields within each line using the new “From Text/CSV” function from the Get & Transform Data group, there is a problem.Īfter a file is selected, the window showing the first lines of the file with the drop-downs “File Origin”, “Delimiter”, and “Data Type Detection” will not appear as shown in the above example. I wanted to add some useful information to this discussion Henrik, thank you for posting this very useful information. In order to achieve this, click on “Close & Load” in the top-left corner.
Recommendation: Select several date columns at the same time by pressing and holding the Ctrl key while selecting the columns. Repeat the steps 5 to 10 for each date column. In this example, the German date format is used. Alternatively click on the small “ABC” symbol in the top left corner of the column heading.